XF 2.1 how do I Silent Edit 194,851 post messages

[rootsxrocks]

I don't really want to change them but I would like to make old links Unfurl and the broken video links embed
this works when I edit any old post and save without modifying, can I make this happen automatically.
or am I missing some obvious way this is done Rebuild threads didn't work

 

[rootsxrocks]

kinda for a similar purpose but might be a different area, can I find and replace a string of text in every post, like urlA.com/subfolder/image.* to urlB.com/subfolder/image.*
I tried doing it in phpmyadmin but it broke the databases every time.
and wither I can do that or not can I just remove all of certian bb codes ?

 

[Alpha1]

This should work in phpmyadmin unless the urls contain problematic symbols:
UPDATE xf_post SET message = REPLACE(message, 'urlA.com/subfolder/image.', 'urlB.com/subfolder/image.');

 

[rootsxrocks]

well now you mention it some are problematic , I have some elderly >75yr who have posted at lot of hotlinks that got converted with bad extensions it be nice to truncate them , like this but not all are the same additional characters http://old.com/forum/images/imported/2019/02/86749c40990b4d7e9466a00f091c2202-1.jpg?b=t[/IMG]

 

[Alpha1]

How about doing this:
UPDATE xf_post SET message = REPLACE(message, 'http://old.com/forum/images/imported/2019/02/', 'urlB.com/subfolder/');
Test on your DB copy. Please not your live one.