The above query works well for [SIGPIC][/SIGPIC]
However, I would also like to replace / remove all sigpic code with anything inbetween. i.e.
[SIGPIC]whatever[/SIGPIC]
How do I do this? Can I simply throw a * in the query? i.e.:
Code:
UPDATE xf_user_profile
SET signature = REPLACE(signature, '[SIGPIC]*[/SIGPIC]', '');