MySQL Query to Get a Random Post from WordPress Database
SELECT DISTINCT p.ID, p.post_title FROM wp_posts p WHERE p.post_type = ‘post’ AND p.post_status = ‘publish’ AND p.post_modified > ‘2018-09-01 00:00:00’ ORDER BY RAND() LIMIT 1
SQL Query to Get Posts Using Category Name
select p.id, p.post_title from wp_posts p inner join wp_term_relationships tr on tr.object_id = p.ID inner join wp_terms t on tr.term_taxonomy_id = t.term_id inner join wp_term_taxonomy tt on tt.term_taxonomy_id = t.term_id …
MySQL Query to List WordPress Posts Using Meta Query
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 …