Recently I regenerated the thumbnails using "Regenerate Thumbnail" plugin after modifying the plugin to delete old thumbnails. All went fine, now old thumbnails has been deleted and I can see the new ones.
Now the problem I am seeing is there are post which has hard codes images, example as below image url http://nezone.info/wp-content/uploads/2013/11/OSA_Football01-580x385.jpg. Since old thumbnails has been deleted image is now not showing in the post. I can see those post using this sql query:
I am wondering how we can update the above url as http://nezone.info/wp-content/uploads/2013/11/OSA_Football01.jpg
I tried with below query which comes out as "0 rows affected", so wondering any one of hack can provide me a solution.
post_content= replace(post_content, '%-%x%.jpg%', '%.jpg%')