• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.4 CORRECT ME THAT SQL

jamalfree

Active member
#1
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
#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:

jamalfree

Active member
#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', '