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/');