General Community > Scripting Help

need help with MySQL query

(1/1)

phantomm:
Hi, after conversion from IPB linked images looks like this:

--- Code: ---[url=\\\"http://www.example.pl\\\"][img]http://www.example.pl/example_img.png[/img][/url]
--- End code ---

what query i need to run in my database to change it to:

--- Code: ---[url=http://www.example.pl][img]http://www.example.pl/example_img.png[/img][/url]
--- End code ---

I need to change:


--- Code: ---[url=\\\"
--- End code ---
to

--- Code: ---[url=
--- End code ---

and


--- Code: ---\\\"]
--- End code ---
to

--- Code: ---]
--- End code ---

I tried:

--- Code: ---UPDATE `smf_members` SET signature = replace(`signature`, '\\\"]',']');
UPDATE `smf_members` SET signature = replace(`signature`, '[url=\\\"','[url=');
--- End code ---

but obviously didn't worked :|

So what query should I run?

CapadY:
This is a real funny one :)

A backslash is an escape sign. to escape an escape sign you'll have to enter it twice.

So, \\\ will be \\\\\\

Luck,
 

phantomm:
Thanks :)

Navigation

[0] Message Index