select * from statsa where aref='AA1270'INSERT INTO statsa (aref,astart,alast,atct,apct,aact,asct,abct) VALUES('AA1270','2010/09/03','2010/09/03',1053,616,406,31,0) on duplicate key UPDATE alast='2010/09/03',atct=1053,apct=616,aact=406,asct=31,abct=0