select * from statsa where aref='AI1370'INSERT INTO statsa (aref,astart,alast,atct,apct,aact,asct,abct) VALUES('AI1370','2010/09/03','2010/09/03',337,192,144,1,0) on duplicate key UPDATE alast='2010/09/03',atct=337,apct=192,aact=144,asct=1,abct=0