[mimoon12]

sql 필드 내의 부분 문자열(큰 따옴표가 들어간) 변경하기

update wp_posts SET post_content= REPLACE(post_content, '<a href=\"https://pentalogia.com/\" target=\"_blank\"><span style=\"margin-left: 0.3em; border: 1px dotted orange;\"> 개인블로그', '<a href=\"http://pentalogia.com/\" target=\"_blank\"><span style=\"margin-left: 0.3em; border: 1px dotted orange;\"> 개인블로그') WHERE ID=10

update wp_posts SET post_content= REPLACE(post_content, '<a href=\"https://pentalogia.com/\" target=\"_blank\"><span style=\"margin-left: 0.3em; border: 1px dotted orange;\"> 개인블로그', '<a href=\"http://pentalogia.com/\" target=\"_blank\"><span style=\"margin-left: 0.3em; border: 1px dotted orange;\"> 개인블로그')

update wp_posts SET post_author= REPLACE(post_author, '1', '376') WHERE ID=2 

update wp_posts SET post_author= REPLACE(post_author, '1', '376') WHERE post_author='1' 

[글쓴이]

글