select * from statsa where aref='AM0196'INSERT INTO statsa (aref,astart,alast,atct,apct,aact,asct,abct) VALUES('AM0196','2010/09/03','2010/09/03',277,121,146,10,0) on duplicate key UPDATE alast='2010/09/03',atct=277,apct=121,aact=146,asct=10,abct=0