mysql 批量查找和替换

批量查找:

        SELECT a.products_name FROM nike.products_description a WHERE a.products_name like '%#%'

#为要查找的字符串

 

 

批量替换:

UPDATE article SET
content = replace(content, ’sjolzy’, ’sjolzy.cn')
WHERE name like '%#%';

article为表 content为字段  sjolzy为要被替换的  sjolzy.cn为替换的值