Hoping some of the MySQL gurus in this forum can help me with a query
I have a custom field called "Image" associated with most of the posts in the database, which holds the full path to the post's image, such as http://mydomain.com/images/imagename.jpg
I'd like to strip the path out of the value and just leave the image name, and instead put the path in the template where the image is called.
This is to simplify the process for a multi-author blog where quite a few of the authors seem to get the path wrong frequently.
Can this be done with a query?