select * from statsa where aref='AI0829'INSERT INTO statsa (aref,astart,alast,atct,apct,aact,asct,abct) VALUES('AI0829','2010/09/03','2010/09/03',236,120,100,16,0) on duplicate key UPDATE alast='2010/09/03',atct=236,apct=120,aact=100,asct=16,abct=0