常用的sql命令

25 January 2019

MySQL命令

替数据表中某个字段中的部份内容

UPDATE `topic`
SET `preImage` = REPLACE (`preImage`, '7xstyo.com2.z0.glb.clouddn.com', 'wdyzj.wodedata.com')
WHERE id IN (
  select id from (
      SELECT id FROM `topic` WHERE `preImage` LIKE '%7xstyo.com2.z0.glb.clouddn.com%' 
  ) tempC
)