Not Solved Vb4.25 merge to 1822
#2
Not Solved
above given query should work !

anyway, you can try using REPLACE instead of regexp_replace like below
UPDATE `mybb_posts` SET `message` = REPLACE (`message`, 'video=youtube;[^\]]+]', 'video=youtube]') WHERE `message` LIKE '%video=youtube%' 

Edit: are you referring to MSSQL [microsoft sql] ? [see replace query]
Reply


Messages In This Thread
Vb4.25 merge to 1822 - by Seeker-Smith - 2020-01-25, 05:24 PM
RE: Vb4.25 merge to 1822 - by .m. - 2020-01-26, 02:27 AM
RE: Vb4.25 merge to 1822 - by Seeker-Smith - 2020-01-26, 03:55 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)