select * from statsa where aref='AI1166'INSERT INTO statsa (aref,astart,alast,atct,apct,aact,asct,abct) VALUES('AI1166','2010/09/03','2010/09/03',1900,1140,591,169,0) on duplicate key UPDATE alast='2010/09/03',atct=1900,apct=1140,aact=591,asct=169,abct=0