There are my arguments for my custom WP_Query
.
$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.
compare
parameter can be used in meta/date queries? Check out the WP_Query docs.