SQL 模糊替换列的值

SELECT * FROM products WHERE path LIKE '%ZJJYAA_%'

UPDATE products SET path = REPLACE(path,SUBSTRING(path,LOCATE(path,'ZJJYAA')),'SHAA')



SELECT * FROM products WHERE path LIKE '%ZJJYAA_%'
SELECT LOCATE('ZJJYAA',path) FROM products WHERE path LIKE '%ZJJYAA_%'
SELECT SUBSTRING(path,LOCATE('ZJJYAA',path), 6)  FROM products WHERE path LIKE '%ZJJYAA_%'
SELECT REPLACE(path,SUBSTRING(path,LOCATE('ZJJYAA',path), 6),'SHAA')  FROM products WHERE path LIKE '%ZJJYAA_%'

UPDATE products SET path = REPLACE(path,SUBSTRING(path,LOCATE('ZJJYAA',path), 6),'SHAA') WHERE path LIKE '%ZJJYAA%'