2020-01-25, 05:24 PM
After doing a merge none of the youtube video links work. Here is why. The top is VB.
One the great folks here supplied me this but it does not work with msql 5.7
If someone can help me do a search and replace with phpMyAdmin, I'd love to buy a coffee.
Also future users may find this helpful in merges.
video=youtube;osHhWnSP5Gc]https://www.youtube.com/watch?v=osHhWnSP5Gc[/video]
video=youtube]https://www.youtube.com/watch?v=osHhWnSP5Gc[/video]
One the great folks here supplied me this but it does not work with msql 5.7
update mybb_posts set message=regexp_replace(message, 'video=youtube;[^\]]+]', 'video=youtube]')
If someone can help me do a search and replace with phpMyAdmin, I'd love to buy a coffee.
Also future users may find this helpful in merges.