Regex mysql for any term

Question

I need to replace any div and any term inside div on my code.

in PHP is like this:

$newbody = str_replace('<div(.*?)>','',$body);

But in Mysql i have this structure to replace words:

UPDATE `wp_posts` SET `post_content` = replace(post_content, '<div(.*?)>', '');# <- thats wrong

thanks guys.

I need to do that because I want to clean my bd from all DIV tags — jose kaizer, Apr 19 '13 at 17:57

score 3 · Answer 1 · answered Apr 19 '13 at 17:56

3

There's not such thing as MySQL replacement with regular expressions, but you could try this

answered Apr 19 '13 at 17:56

1 Answers1