select * from statsa where aref='AA1686'INSERT INTO statsa (aref,astart,alast,atct,apct,aact,asct,abct) VALUES('AA1686','2010/09/03','2010/09/03',129,65,59,5,0) on duplicate key UPDATE alast='2010/09/03',atct=129,apct=65,aact=59,asct=5,abct=0