select * from statsa where aref='AA1650'INSERT INTO statsa (aref,astart,alast,atct,apct,aact,asct,abct) VALUES('AA1650','2010/09/03','2010/09/03',703,450,225,28,0) on duplicate key UPDATE alast='2010/09/03',atct=703,apct=450,aact=225,asct=28,abct=0