SQL 특정 문자 일괄변경 맞나요. 채택완료
UPDATE some_table SET some_field = REPLACE(some_field, '원래것', '바뀔것')
some_table 은 원하는 테이블
some_field 는 변경하고자 하는 필드
원래것 = AAA
바뀔것 = BBB
위와 같이 만하면 되나요.
혹시 뒤쪽에 다른 것 첨가 시켜야 하나요?
UPDATE some_table SET some_field = REPLACE(some_field, '원래것', '바뀔것') + ??????????
조언 부탁합니다.
답변 5개
댓글을 작성하려면 로그인이 필요합니다.
some_field 내용은 abcde 라고 가정
아래 질의
</font></strong> UPDATE</span><span class="pln" style='margin: 0px; padding: 0px; border: 0px currentColor; border-image: none; line-height: 17.8px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, serif; font-size: 14px; vertical-align: baseline; white-space: inherit;'> some_table </span><span class="kwd" style='margin: 0px; padding: 0px; border: 0px currentColor; border-image: none; color: rgb(0, 0, 139); line-height: 17.8px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, serif; font-size: 14px; vertical-align: baseline; white-space: inherit;'>SET</span><span class="pln" style='margin: 0px; padding: 0px; border: 0px currentColor; border-image: none; line-height: 17.8px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, serif; font-size: 14px; vertical-align: baseline; white-space: inherit;'> some_field </span><span class="pun" style='margin: 0px; padding: 0px; border: 0px currentColor; border-image: none; line-height: 17.8px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, serif; font-size: 14px; vertical-align: baseline; white-space: inherit;'>=</span><span class="pln" style='margin: 0px; padding: 0px; border: 0px currentColor; border-image: none; line-height: 17.8px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, serif; font-size: 14px; vertical-align: baseline; white-space: inherit;'> REPLACE</span><span class="pun" style='margin: 0px; padding: 0px; border: 0px currentColor; border-image: none; line-height: 17.8px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, serif; font-size: 14px; vertical-align: baseline; white-space: inherit;'>(</span><span class="pln" style='margin: 0px; padding: 0px; border: 0px currentColor; border-image: none; line-height: 17.8px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, serif; font-size: 14px; vertical-align: baseline; white-space: inherit;'>some_field</span><span class="pun" style='margin: 0px; padding: 0px; border: 0px currentColor; border-image: none; line-height: 17.8px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, serif; font-size: 14px; vertical-align: baseline; white-space: inherit;'>,</span><span class="pln" style='margin: 0px; padding: 0px; border: 0px currentColor; border-image: none; line-height: 17.8px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, serif; font-size: 14px; vertical-align: baseline; white-space: inherit;'> </span><span class="str" style='margin: 0px; padding: 0px; border: 0px currentColor; border-image: none; color: rgb(128, 0, 0); line-height: 17.8px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, serif; font-size: 14px; vertical-align: baseline; white-space: inherit;'>'bcd'</span><span class="pun" style='margin: 0px; padding: 0px; border: 0px currentColor; border-image: none; line-height: 17.8px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, serif; font-size: 14px; vertical-align: baseline; white-space: inherit;'>,</span><span class="pln" style='margin: 0px; padding: 0px; border: 0px currentColor; border-image: none; line-height: 17.8px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, serif; font-size: 14px; vertical-align: baseline; white-space: inherit;'> </span><span class="str" style='margin: 0px; padding: 0px; border: 0px currentColor; border-image: none; color: rgb(128, 0, 0); line-height: 17.8px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, serif; font-size: 14px; vertical-align: baseline; white-space: inherit;'>'xxx'</span><span class="pun" style='margin: 0px; padding: 0px; border: 0px currentColor; border-image: none; line-height: 17.8px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, serif; font-size: 14px; vertical-align: baseline; white-space: inherit;'>)</span><span style="line-height: 1.5; font-size: 10pt;"></span> <strong>
그러면 some_field 내용은 axxxe 가 됩니다.
댓글을 작성하려면 로그인이 필요합니다.
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인