I’d use your custom field directly, without mysql:
<?php if ( get_post_meta($post->ID, 'imagename', true) ) { ?>
<img src="<?php bloginfo('url'); ?>/images/<?php echo get_post_meta($post->ID, "imagename", $single = true); ?>.jpg" alt="image" />
<?php } ?>
For an custom field called “imagename.” Change .jpg to .gif if needed, or have authors enter the image suffix as part of the custom field.
Hi songdogtech
Thanks for the reply, but that is how I use the custom field – the problem is that the value in that custom field now (for all the posts) includes the full path, and that’s what I want to strip out of the db using a SQL query, instead of having to go back through almost 600 posts to manually remove the path, leaving just the image name.
Then I can hard-code the path into the template and not have to continually monitor and correct when the authors make a typo in the path name (unfortunately it’s a long one, leaving it ripe for typos)
So what I need is how to word a SQL query to strip out the path from the custom field’s value, and leave just what follows the last / which is the image name.
Any suggestions?
Sorry, didn’t get what you were after. I use Search RegEx to search and replace with Grep through all posts and pages, or Search and Replace « WordPress Plugins works right on the database.
Perhaps this will help:
UPDATE wp_postmeta
SET meta_value = mid(meta_value,7+locate(‘images’,meta_value))
WHERE meta_key = ‘Image’
You can see what you are going to update with this:
SELECT mid(meta_value,7+locate(‘images’,meta_value))
FROM wp_postmeta
WHERE meta_key = ‘Image’
