Use a ternary operation to keep it trim. array( ‘key’ => ‘rob_value’, ‘value’ => $rob, ‘compare’ => ( empty( $rob ) ? ‘!=’ : ‘=’ ) ); Breakdown, incase you’ve not seen ternary operators before.. array( ‘key’ => ‘rob_value’, ‘value’ => $rob, ‘compare’ => ( // If empty( $rob ) // Then ? ‘!=’ // … Read more
In most cases its better to store the meta as a single array and in that save database queries. The only down side to storing the data as an array is it’s nearly impossible to query based on sirealized data. So my rule is if i need to query based on that data the it … Read more
If you’re using WP_Query to do your loop it should be as simple as getting all the post IDs and then setting them as negative in the p parameter. For example: $unwanted_posts = array(); // you must generate this $unwanted_posts_str=”-“.implode( ‘,-‘, $unwanted_posts ); $args = array( ‘p’ => $unwanted_posts_str ); You can also set this … Read more
If you want to match them all, you have to add ‘relation’ => ‘AND’ and check for each value separately: $args = array( ‘post_type’ => ‘post’, ‘meta_query’ => array( ‘relation’ => ‘AND’, array( ‘key’ => ‘_some_meta_key’, ‘value’ => 1, ‘compare’ => ‘=’ ), array( ‘key’ => ‘_some_meta_key’, ‘value’ => 2, ‘compare’ => ‘=’ ), array( … Read more
‘orderby’ => ‘meta_value_num’ will try to force the value to a number by adding 0. In other words, “2013-09-30 22:00:00″+0 When I tested that both PHP and MySQL converted the string to 2013, which is not what you want. That particular date format, and only that date format, will sort correctly if you just leave … Read more
I am guessing but based on your choice of placeholder names in the code above… $args = array( ‘meta_key’ => ‘myvalue’, ‘orderby’ => ‘meta_value_num’, ‘order’ => ‘DESC’ ); … your meta_key argument is wrong. That is the meta key not the meta value as your naming convention suggests. meta_key (string) – Custom field key. http://codex.wordpress.org/Class_Reference/WP_Query#Custom_Field_Parameters … Read more
The answer by felipelavinz assumes that there is an array of dates stored in the post_meta of each post, but the way I read your question and sample code it seemed as though you have one date specified per post? If this is true (one date per post) then the following would suit you better … Read more
Here are few ideas: 1) You could try to compare with LIKE instead: ‘key’ => ‘_my_custom_field_key’, ‘value’ => ‘test1’, ‘compare’ => ‘LIKE’ It should give you a SQL query with: … LIKE ‘%test1%’ … 2) You might want to save the string as ,test1,test2,test3, to make the whole word search easier: ‘key’ => ‘_my_custom_field_key’, ‘value’ … Read more
I am assuming your custom post type is also “series”. Can you try this, it should work. $args = [ ‘post_type’ => ‘series’, ‘posts_per_page’ => -1, ‘meta_query’ => [ [ ‘key’ => ‘series’, ‘value’ => 19, ‘compare’ => ‘=’, ‘type’=>’NUMERIC’ ] ], ]; $posts = new WP_Query( $args ); or you can simple use: $args … Read more
I found the problem and also fixed a bug in the regex. Final code: ‘meta_query’ => array( array( ‘key’ => ‘my_meta_field’, ‘value’ => “(^|\n|\r\n)99999($|\n|\r\n)”, ‘compare’ => ‘REGEXP’, ), ), The problem here was WordPress was adding extra backslashes on the special characters. By wrapping the expression in double quotes, this problem was solved. Also added … Read more