indie Posted May 15, 2019 Share Posted May 15, 2019 I'm looking to clean up some old vBulletin BBcode. I want to remove the actual codes and what is between them. So for example, I want to remove: [QT]random text here alpha-numeric etc.[/QT] Thanks! Link to comment Share on other sites More sharing options...
chhorn Posted May 15, 2019 Share Posted May 15, 2019 yeah, try something then? Link to comment Share on other sites More sharing options...
gizmola Posted May 17, 2019 Share Posted May 17, 2019 MariaDB and MySQL 8 both have REGEXP_REPLACE. A regex like this would probably work to find your bbcode: \[QT\].*\[\/QT\] Replace that with and empty string, and you'll remove the bbcode blocks from the messages. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.