select * from statsa where aref='AI1445'INSERT INTO statsa (aref,astart,alast,atct,apct,aact,asct,abct) VALUES('AI1445','2010/09/03','2010/09/03',233,153,75,5,0) on duplicate key UPDATE alast='2010/09/03',atct=233,apct=153,aact=75,asct=5,abct=0