select * from statsa where aref='AI1052'INSERT INTO statsa (aref,astart,alast,atct,apct,aact,asct,abct) VALUES('AI1052','2010/09/03','2010/09/03',1693,1107,542,44,0) on duplicate key UPDATE alast='2010/09/03',atct=1693,apct=1107,aact=542,asct=44,abct=0