select * from statsa where aref='AA1635'INSERT INTO statsa (aref,astart,alast,atct,apct,aact,asct,abct) VALUES('AA1635','2010/09/03','2010/09/03',2394,1258,993,143,0) on duplicate key UPDATE alast='2010/09/03',atct=2394,apct=1258,aact=993,asct=143,abct=0