mysql 함수 사용법

1. replace(내용 치환하기)

 

SELECT * FROM test WHERE contents LIKE '%aaa%';

SELECT REPLACE(contents, 'aaa', 'bbb') AS new_contents FROM test;

UPDATE test SET contents = REPLACE(contents, 'aaa', 'bbb');