批量查找:
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为替换的值
作者: Sjolzy
--EOF--
