select * from statsa where aref='AM0182'INSERT INTO statsa (aref,astart,alast,atct,apct,aact,asct,abct) VALUES('AM0182','2010/09/03','2010/09/03',2583,1864,618,101,0) on duplicate key UPDATE alast='2010/09/03',atct=2583,apct=1864,aact=618,asct=101,abct=0