[RSS Feed/News] Mysql strings to replace characters

[XenForo]

I need 3 mysql strings to replace things.
First one is like this:
Code:

UPDATE xf_post SET message = REPLACE(message, '>', '>');
but this gives an error in the used syntax at "> it says. While there is only one ' in the string there.

The second one is the same, but then for < which needs to be replace to a < character.

The third one is trickier. I need the " be changed to the " character.

Maybe some others can benefit from this too as...

Read more

ادامه مطلب...