XF 1.4 Removing an irrelevant BBCode en masse from database?

[MichaelCS]

Good Morning XF!

I just recently migrated from SMF to XenForo and I have a bunch, a BUNCH of clean up work to do. Part of that is stripping out things from the posts that are no longer relevent.

Is there a way to do a database query (or whatever it is called) that will strip out [smurfy] and [/smurfy] from all my posts? Going through 50000 posts to ensure that none of them have this old BBCode would really be ummm less than ideal.

 

[Paul B]

You can do a simple query to remove post content if the strings you are removing are identical, but if you also want to remove the content between the tags, you should use this add-on: https://xenforo.com/community/resources/post-content-find-replace.1549/

 

[MichaelCS]

I can keep the content between the tags just need the tags gone. Do you know the query I would run to do this?

 

[Paul B]

An example query would be:

UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');

 

[MichaelCS]

UPDATE xf_post SET message = REPLACE(message,'[smurfy]','');

So like that? Replacing the new content with nothing is okay or do I need a space in there?

 

[Paul B]

That should do it.

Take a backup first, just in case.