Hello so I have as lot of images stored in a MYSQL ext_thumb
The url looks like this:
https://67.media.tumblr.com/d219dcbf889820dd99f1d64547e8e42b/tumblr_od7seakpNy1vwrt93o1_540.png
Is there a way to mass change the
https://67.media.tumblr.com
to
https://68.media.tumblr.com
on all of the posts?
I'm currently doing it 1 by 1 but it's a bit time consuming.
__________________
Added after 28 minutes:
Got it working.
This code worked:
UPDATE MyTable
SET text_thumb = REPLACE (text_thumb, 'https://67', 'https://68')
WHERE text_thumb is not NULL;
The url looks like this:
https://67.media.tumblr.com/d219dcbf889820dd99f1d64547e8e42b/tumblr_od7seakpNy1vwrt93o1_540.png
Is there a way to mass change the
https://67.media.tumblr.com
to
https://68.media.tumblr.com
on all of the posts?
I'm currently doing it 1 by 1 but it's a bit time consuming.
__________________
Added after 28 minutes:
Got it working.
This code worked:
UPDATE MyTable
SET text_thumb = REPLACE (text_thumb, 'https://67', 'https://68')
WHERE text_thumb is not NULL;
Last edited: