Regex_replace square brackets not working in SQL query

Asked Dec 15 '21 at 22:58

Active Dec 15 '21 at 22:58

Viewed 23 times

I would like to remove square brackets and content between them from WP posts. I found very helpful topic for similar issue, unfortunately when I am using this regex in SQL query, it's not working - not matches found.

UPDATE wp_posts SET post_content = REGEXP_REPLACE(post_content,'\[(.+?)\]','') WHERE ID = '4186' AND post_type = 'page';

I have tested sql and regex itself, separately - their are working correctly, could anyone point me out the issue?

asked Dec 15 '21 at 22:58

dra89szka

1

Try `'\[[^][]*]'` or - if you need to double backslashes - `'\\[[^][]*]'` – Wiktor Stribiżew Dec 15 '21 at 23:01
Unfortunately, #3696 - The regular expression contains an unclosed bracket expression. – dra89szka Dec 15 '21 at 23:04
Aha, so it is MySQL v.8+. You need `'\\[[^\\]\\[]*]'` – Wiktor Stribiżew Dec 15 '21 at 23:08
1

Basically, `'\\[(.+?)]'` should work, too. – Wiktor Stribiżew Dec 15 '21 at 23:14

Regex_replace square brackets not working in SQL query

0 Answers0