×

WP Assist

Quick & Easy WordPress Assistance

Brought to you by ArchSoft Inc.

Tag: wp_posts

MySQL Query to Get a Random Post from WordPress Database

WPAssist //

SELECT DISTINCT p.ID, p.post_title FROM wp_posts p WHERE p.post_type = 'post' AND p.post_status = 'publish' […]

SQL Query to Get Posts Using Category Name

WPAssist //

select p.id, p.post_title from wp_posts p inner join wp_term_relationships tr on tr.object_id = p.ID inner […]

MySQL Query to List WordPress Posts Using Meta Query

WPAssist //

To get a list of WordPress Posts using meta query in MySQL, you can use […]