When you are creating a custom loop, generally query_posts or WP_Query is more than enough for the job. But if you want to work on an API project that depends on WordPress tables, then you will need to use custom MySQL queries. Here is a […]
Sometimes SQL knowledge is critical for WordPress developers to run mass updates on your posts. In this post, we are sharing an example SQL query to get posts using a category name. This requires database access and some basic SQL knowledge. To get all posts […]
To get a list of WordPress Posts using meta query in MySQL, you can use the following SQL query: SELECT p.ID, p.post_title, m.meta_id, m.meta_key, m.meta_value FROM `wp_posts` p LEFT JOIN `wp_postmeta` m ON p.ID = m.post_id WHERE m.meta_key = ‘wpcf-show-status’ AND m.meta_value ” ORDER BY […]
If you have been using WordPress for a long time, it is possible that you have many spam comments, revisions, transients cache, etc. on your WP database. In this post, I listed the most useful SQL queries you can use to clean up your WordPress […]
