我了解compare 在以下情况下：meta-query, 但我想知道是否有可能compare 在中的另一列上wp_posts 表viaWP_Query. 我先写了这个，效果很好：

    $results = $wpdb->get_results( 
        $wpdb->prepare( 
            \'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\',
             \'post\',
             \'publish\',
             \'Daily Task:\'
        )  
    );  

但是，为了让WordPress完成这项工作，我想要这样的东西：

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

我搜索了互联网和抄本，只找到了meta_query. 那是因为compare, LIKE, 或REGEXP 不适用于WP_Query?

谢谢

add_filter( \'posts_where\', \'my_posts_where\', 10, 2 );
function my_posts_where( $where, $query ) {
    if ( $value = $query->get( \'custom_param\' ) ) {
        global $wpdb;
        $like = $wpdb->esc_like( $value ) . \'%\';
        $where .= " AND {$wpdb->posts}.post_title LIKE \'$like\'";
    }

    return $where;
}

// In your template or code:
$query = new WP_Query( array(
    \'custom_param\' => \'Daily Task:\',
    // .. other args
) );