jamalfree Active member Jan 30, 2016 #1 PHP: update xf_post set `message`= replace (`message` , '[URL='http://(y)'][IMG]http://www.xxx.net/pic/thanx/7.gif[/IMG][/URL]' , '(y)');
PHP: update xf_post set `message`= replace (`message` , '[URL='http://(y)'][IMG]http://www.xxx.net/pic/thanx/7.gif[/IMG][/URL]' , '(y)');
Mouth Well-known member Jan 30, 2016 #2 Code: update xf_post set message = replace(message, '[URL=\'http://(y)\'][IMG]http://www.xxx.net/pic/thanx/7.gif[/IMG][/URL]', '(y)'); Last edited: Jan 30, 2016 Upvote 0 Downvote
Code: update xf_post set message = replace(message, '[URL=\'http://(y)\'][IMG]http://www.xxx.net/pic/thanx/7.gif[/IMG][/URL]', '(y)');
jamalfree Active member Jan 30, 2016 #3 didnt work #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''message' = replace('message', ' Upvote 0 Downvote
didnt work #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''message' = replace('message', '
Mouth Well-known member Jan 30, 2016 #4 jamalfree said: didnt work Click to expand... Edited. Minor syntax correction. Try again. Upvote 0 Downvote
