Is there a ‘compare’ option when using WP_Query apart from meta_query


I understand the use of compare in the context of meta-query, but I’d like to know if it’s possible to do a compare on another column in the wp_posts table via WP_Query. I wrote this first, which works fine:

    $results = $wpdb->get_results( 
            'SELECT id, post_title, post_name  
             FROM '.$wpdb->prefix.'posts
             WHERE post_type = %s  
             AND post_status = %s
             AND post_title REGEXP "%s"
             ORDER BY post_date ASC',
             'Daily Task:'

but in trying to let WordPress do the work, I would like something like this:

    $results = new WP_Query( array (
        'post_type'   => 'post',
        'post_status' => 'publish',
        'orderby'     => 'post_date',
        'relation'    => 'AND',
        array ( 'compare'     => 'LIKE%',
                'post_title'  => 'Daily Task: '

I’ve searched the Interwebs and the Codex and all I find are references to meta_query. Is that because compare, LIKE, or REGEXP doesn’t apply to WP_Query?


breadwild 1 month 0 Answers 11 views 0

Leave an answer