Databases
mysql 데이터 치환하기 (REPLACE)
duraboys
2018. 4. 10. 02:45
SELECT * FROM Table WHERE content LIKE '%aaa%';
SELECT REPLACE(content, 'aaa', '/upload2/bbb/') AS 'replaced' FROM myTable;
UPDATE myTable SET content = REPLACE(content, 'aaa', '/bbb/');