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 […]
SQL is a great tool if you want to make changes to all your posts at once. Especially if you want to replace some old string with new ones it will be really helpful. In this post, I am going to show you how you […]
