select * from statsa where aref='AA1649'INSERT INTO statsa (aref,astart,alast,atct,apct,aact,asct,abct) VALUES('AA1649','2010/09/03','2010/09/03',1022,511,471,40,0) on duplicate key UPDATE alast='2010/09/03',atct=1022,apct=511,aact=471,asct=40,abct=0