select * from statsa where aref='AA1693'INSERT INTO statsa (aref,astart,alast,atct,apct,aact,asct,abct) VALUES('AA1693','2010/09/03','2010/09/03',564,284,263,17,0) on duplicate key UPDATE alast='2010/09/03',atct=564,apct=284,aact=263,asct=17,abct=0