Replacing content in multiple topics with Regex?

Amazing! worked perfectly, been reading the post you linked and im trying to build a regex for removing RGB BB code.

RegEx builder states my regex is valid:

However when running it, it either updates 0 posts or I get an error stating it isn’t a valid regex.

This his how the BBcode is in topics:

[COLOR=rgb(95, 66, 222)]

Also tried this:

rake posts:delete_word[‘[\WCOLOR=rgb(\d{1,3}), (\d{1,3}), (\d{1,3})(, ){0,1}(0(\.\d+)?|1(\.0+)?)]’,‘regex’]