In a CMS database there is an image url in some entries that needs to be changed, with 100+ pages it will take a long time to do manually. Is there a find/replace function with SQL that I can run to change them all?
I only know small amounts about databases, I want to accomplish:
/images/imagename.gif changed to /images/imagehere.jpg
Any help would be appreciated
Thanks
Mike