There are my arguments for my custom
$args = array( 'post_type' => 'post', 'posts_per_page' => '9', 'name'=>'Products', 'compare'=>'LIKE' ); $the_query = new WP_Query( $args ); echo $the_query->request;
which returns the following query:
SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = 'products' AND wp_posts.post_type = 'post' ORDER BY wp_posts.post_date DESC
As I can see, this is not creating a
LIKE query like I'd like to have one.