Regex in MySql - replace between Tags including Tags
- by user998163
I have a text like:
[lang_de]Content in German[/lang_de][lang_en]Content in English[/lang_en].
I want to replace all text between [lang_en] and [/lang_en] including the opening and closing language tag.
This is my current regex:
UPDATE wp_posts SET post_content = '" . addslashes(preg_replace("/[lang_en](.*)[\/lang_en]/", '',…