Wordpress Get Post Id By Meta Value

WordPress: Get Post ID by Meta Value

If you are into developing custom themes for WordPress, you probably know how useful it can be to use custom meta fields in your posts. But only adding those fields is not enough. You need custom loops or functions to filter/get your posts using those meta values. In this post, we share with you a […]

Read more WordPress: Get Post ID by Meta Value

MySQL Query to Get a Random Post from WordPress Database

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 custom MySQL query to get a random post from the […]

Read more MySQL Query to Get a Random Post from WordPress Database

12+ Useful SQL Queries for WordPress Database Cleanup

If you are 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 most useful SQL queries you can use to clean up your WordPress database and reduce its size around 85%! [toc] Tools Required My favorite tool for […]

Read more 12+ Useful SQL Queries for WordPress Database Cleanup