select * from statsa where aref='AE0732'INSERT INTO statsa (aref,astart,alast,atct,apct,aact,asct,abct) VALUES('AE0732','2010/09/03','2010/09/03',353,125,217,11,0) on duplicate key UPDATE alast='2010/09/03',atct=353,apct=125,aact=217,asct=11,abct=0