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