select * from statsa where aref='AI1065'INSERT INTO statsa (aref,astart,alast,atct,apct,aact,asct,abct) VALUES('AI1065','2010/09/03','2010/09/03',1419,939,424,56,0) on duplicate key UPDATE alast='2010/09/03',atct=1419,apct=939,aact=424,asct=56,abct=0