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为替换的值

 

本文永久地址:https://sjolzy.cn/Batch-Find-and-Replace-mysql.html

--EOF--

随机文章

添加新评论