select * from statsa where aref='AI1150'INSERT INTO statsa (aref,astart,alast,atct,apct,aact,asct,abct) VALUES('AI1150','2010/09/03','2010/09/03',194,105,87,2,0) on duplicate key UPDATE alast='2010/09/03',atct=194,apct=105,aact=87,asct=2,abct=0