InfoHeap
Tech tutorials, tips, tools and more
Navigation
  • Home
  • Tutorials
    • CSS tutorials & examples
    • CSS properties
    • Javascript cookbook
    • Linux/Unix Command Line
    • Mac
    • PHP
      • PHP functions online
      • PHP regex
    • WordPress
  • Online Tools
    • Text utilities
    • Online Lint Tools
search

Wordpress Mysql Query tutorials

  • How to delete orphan wordpress wp_postmeta rows
  • Mysql query to find all yoast meta description
  • Query to find recently modified posts in Wordpress
  • Wordpress - an approach to bulk add tags to posts
  • Wordpress - query to dump all categories
  • Wordpress - query to dump all posts with featured image
  • Wordpress - query to dump all tags
  • Wordpress - query to find all posts for a category
  • Wordpress - query to find term_taxonomy_id from category name
  • Wordpress - query to find term_taxonomy_id from tag name
  • Wordpress mysql query to get all custom keys and values for a post
  • Wordpress mysql query to get all posts with a missing custom field
  • Wordpress mysql query to get all posts with a specific custom field
  • migrate multiple mysql databases using mysqldump on Linux
 
  • Home
  • > Tutorials
  • > Wordpress
  • > Wordpress Mysql Queries

WordPress – query to dump all posts with featured image

on Mar 31, 2016

Sometimes we need to dump all post with featured images along with post title and image title. Here is mysql query which lists all posts with featured images. This may be useful for review purpose.

select p1.post_title, p2.post_title from wp_postmeta 
join wp_posts p1 on p1.ID = wp_postmeta.post_id
join wp_posts p2 on p2.ID = wp_postmeta.meta_value
where meta_key='_thumbnail_id'

Suggested posts:

  1. WordPress mysql query to get all posts with a missing custom field
  2. WordPress mysql query to get all posts with a specific custom field
  3. Mysql query to find all yoast meta description
  4. WordPress mysql query to get all custom keys and values for a post
  5. How to delete orphan wordpress wp_postmeta rows
  6. WordPress – an approach to bulk add tags to posts
  7. WordPress – query to dump all categories
  8. How to hide a post from home and RSS feed in wordpress
Share this article: share on facebook share on linkedin tweet this submit to reddit
Posted in Tutorials | Tagged Tutorials, Wordpress, Wordpress Mysql Queries

Follow InfoHeap

facebook
twitter
googleplus
  • Browse site
  • Article Topics
  • Article archives
  • Recent Articles
  • Contact Us
  • Omoney
Popular Topics: Android Development | AngularJS | Apache | AWS and EC2 | Bash shell scripting | Chrome developer tools | CSS | CSS cookbook | CSS properties | CSS Pseudo Classes | CSS selectors | CSS3 | CSS3 flexbox | Devops | Git | HTML | HTML5 | Java | Javascript | Javascript cookbook | Javascript DOM | jQuery | Kubernetes | Linux | Linux/Unix Command Line | Mac | Mac Command Line | Mysql | Networking | Node.js | Online Tools | PHP | PHP cookbook | PHP Regex | Python | Python array | Python cookbook | SEO | Site Performance | SSH | Ubuntu Linux | Web Development | Webmaster | Wordpress | Wordpress customization | Wordpress How To | Wordpress Mysql Queries

Copyright © 2023 InfoHeap.

Powered by WordPress