select * from statsa where aref='AI1140'INSERT INTO statsa (aref,astart,alast,atct,apct,aact,asct,abct) VALUES('AI1140','2010/09/03','2010/09/03',419,207,179,33,0) on duplicate key UPDATE alast='2010/09/03',atct=419,apct=207,aact=179,asct=33,abct=0