select * from statsa where aref='AM0270'INSERT INTO statsa (aref,astart,alast,atct,apct,aact,asct,abct) VALUES('AM0270','2010/09/03','2010/09/03',519,318,186,15,0) on duplicate key UPDATE alast='2010/09/03',atct=519,apct=318,aact=186,asct=15,abct=0