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