MyBB Community Forums

I need to remove the following texts from all posts.

[USER=1234]@Username1[/USER]
[USER=3454]@Another User1[/USER]
[USER=2321]@Username3[/USER]

etc.

Please provide me the sql query to execute to remove all texts in bulk.

Thanks.

I think it's going to take a little more then a SQL query to do what you want, but I could be wrong. Can't you just use the bad word filter as I work around?

Bad Filter is considering wildcard * as a single character. That's why I can not omit all instances.