select * from statsa where aref='AI1030'INSERT INTO statsa (aref,astart,alast,atct,apct,aact,asct,abct) VALUES('AI1030','2012/01/27','2012/01/27',728,288,406,31,0) on duplicate key UPDATE alast='2012/01/27',atct=728,apct=288,aact=406,asct=31,abct=0