Replace All Thumbnail URL in SQL Database using a script

[jonahgirl]

I use a script (I didn’t write it) when I move a site from development to the live working server to change all the urls on my wp tables.

I would like to do the same when the site involves eStore.

The issue is mostly with Thumbnail urls…

I am not sure how to write it…would this be correct?

UPDATE wp_wp_eStore_tbl SET thumbnail_url = replace(thumbnail_url, ‘http://wordpress.devsite.com’, ‘http://www.domainname.com’);

[amin007]

Yes, it looks correct to me assuming the prefix of your WordPress database is “wp_”

[jonahgirl]

great…actually it is not for this site but that is an easy change. Didn’t want to post actual prefix

[Author]

Posts