sql query: how to grab the “File URL” of every featured image in wordpress?

2 Views

Which is the sql query in order to grab the “File URL”of every featured image(original image/example: http://www.mysite.com.com/wp-content/uploads/2012/photo.jpg) and add it to the beginning of the corresponding post like that example: [wide]http://www.mysite.com.com/wp-content/uploads/2012/photo.jpg[/wide]

Post Views: 2

Related posts

Leave a Reply

2 comments

  1. depending on what you want to do, the better way would be the one suggested by @Sheikh but if you want to do a different thing and need a sql query, this query get all the featured images urls:

    SELECT  ( SELECT guid FROM wp_posts WHERE id = m.meta_value ) AS url 
FROM wp_posts p, wp_postmeta m
WHERE p.post_type =  'post'
AND p.post_status =  'publish'
AND p.id = m.post_id
AND m.meta_key =  '_thumbnail_id'

    Remember you can use this filter too:

    add_filter('the_content', 'add_post_content');

  2. Inside the loop you can use

    <?php

 if ( has_post_thumbnail( $post->ID ) ):
 $imgData = wp_get_attachment_image_src( get_post_thumbnail_id( $post->ID ) ); 
 echo $imgData[0]; // Output: featured image url
 endif; 

?>