티스토리 뷰

공부

[MySQL] replace text

승가비 2020. 6. 13. 20:55
728x90
UPDATE table_name SET field = REPLACE(field, 'foo', 'bar') WHERE INSTR(field, 'foo') > 0;

https://stackoverflow.com/questions/125230/mysql-search-and-replace-some-text-in-a-field

 

MySQL search and replace some text in a field

What MySQL query will do a text search and replace in one particular field in a table? I.e. search for foo and replace with bar so a record with a field with the value hello foo becomes hello bar.

stackoverflow.com

 

728x90
저작자표시 비영리

'공부' 카테고리의 다른 글

[MySQL] default value  (0) 2020.06.13
[MySQL] MySQL Error 1093 : You can't specify target table 'tablename' for update in FROM clause  (0) 2020.06.13
자꾸만 에러가 나오는데 왜그런걸까요?? - 노마드코더  (0) 2020.06.13
[MongoDB] install mongodb  (0) 2020.06.13
Site Reliability Engineering(SRE)  (0) 2020.06.07
댓글