select * from statsa where aref='AM0128'INSERT INTO statsa (aref,astart,alast,atct,apct,aact,asct,abct) VALUES('AM0128','2010/09/03','2010/09/03',3888,1805,2027,56,0) on duplicate key UPDATE alast='2010/09/03',atct=3888,apct=1805,aact=2027,asct=56,abct=0