phpMyAdmin - Find and replace - edit image url

Und alles was mit phpMyAdmin seine Verwandtschaft findet hat hier seinen Platz.

phpMyAdmin - Find and replace - edit image url

Postby okanner48 » 27. July 2014 14:39

I have very old image url like this:

On phpMyAdmin I've used "find and replace code" UPDATE wp_posts SET post_content = REPLACE ( post_content, 'jpg?imgmax=1800', 'jpg');

After updating image url has changed like this:

But I want to write before image name s1600/

Sample link:

Can I change that via find and replace code or...

Thanks in advance.
Posts: 1
Joined: 27. July 2014 14:37
Operating System: linux

Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 5 guests