update tablename set field1=concat(field1,'_bak') where field2 like '%@xxx’

05-04 07:00