select * from statsa where aref='AM0252'INSERT INTO statsa (aref,astart,alast,atct,apct,aact,asct,abct) VALUES('AM0252','2010/09/03','2010/09/03',693,306,368,15,0) on duplicate key UPDATE alast='2010/09/03',atct=693,apct=306,aact=368,asct=15,abct=0