select * from statsa where aref='AI1203'INSERT INTO statsa (aref,astart,alast,atct,apct,aact,asct,abct) VALUES('AI1203','2010/09/03','2010/09/03',248,121,105,22,0) on duplicate key UPDATE alast='2010/09/03',atct=248,apct=121,aact=105,asct=22,abct=0