select * from statsa where aref='AA1288'INSERT INTO statsa (aref,astart,alast,atct,apct,aact,asct,abct) VALUES('AA1288','2010/09/03','2010/09/03',1157,638,421,98,0) on duplicate key UPDATE alast='2010/09/03',atct=1157,apct=638,aact=421,asct=98,abct=0