mysql字段累加concat

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

原文地址:https://www.cnblogs.com/walter371/p/4726797.html