https://www.heckjj.com/index.php zh-cn https://www.heckjj.com/post// Heck <@hecks.tk> Wed, 14 Apr 2021 15:01:13 +0000 https://www.heckjj.com/post//
sql语句：

update 表名 set 字段名=REPLACE (字段名,'原来的值','要修改的值')

update  pmsprojectmember set projectMemberType=REPLACE(projectMemberType,'BusinessOprator','BusinessOperator')

update user_item set addr=REPLACE (addr,'长沙','湘府')

添加条件：
update user_item set addr=REPLACE (addr,'长沙','湘府') where time<'2021-1-5'；
]]> https://www.heckjj.com/post//#blogcomment <user@domain.com> Thu, 01 Jan 1970 00:00:00 +0000 https://www.heckjj.com/post//#blogcomment