indie Posted May 15, 2019 Share Posted May 15, 2019 (edited) 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! Edited May 15, 2019 by indie Quote Link to comment https://forums.phpfreaks.com/topic/308707-query-needed-thanks/ Share on other sites More sharing options...
chhorn Posted May 15, 2019 Share Posted May 15, 2019 yeah, try something then? Quote Link to comment https://forums.phpfreaks.com/topic/308707-query-needed-thanks/#findComment-1566747 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. Quote Link to comment https://forums.phpfreaks.com/topic/308707-query-needed-thanks/#findComment-1566805 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.