A rought method would be to set value of balance to ‘mt1.meta_value’ and then use a ‘posts_request’ filter to remove the escaping quotes: $args = array( ‘post_type’ => ‘post’, // maybe not ‘meta_query’ => array( array( ‘key’ => ‘balance’, ‘compare’ => ‘>=’, ‘value’ => ‘mt1.meta_value’, // this will be treated as a string ‘type’ => … Read more
First, your date format has to be in descending order from largest to smallest units, i.e.: year, month, day, hour, minute, second, etc., otherwise MySQL can’t query or order on the field. In this example I use year – month – day: $today = date( ‘Y-m-d’ ); $args = array( ‘post_type’ => ‘vehicle’, ‘meta_query’ => … Read more
The meta_value is not of an integer type for max to return proper values. You can use mysql cast method to convert into integers as follows: SELECT max(cast(meta_value as unsigned)) FROM wp_postmeta WHERE meta_key=’price’
please never do this: ‘value’ => $_GET[‘s’] … $query->get(‘s’);, get_search_query, or sanitize_key($_GET[‘s’]) are all safer options. Technically we shouldn’t be using get-params in wordpress at all, it’s not a best-practice. That get value could be all sorts of bad things, & we don’t want to pass it along to the db without making sure it’s … Read more
The query looks about right and I know that meta_query and tax_query work together just fine. the only thing i can think of is that you are query taxonomy by slug and passing the term id which are two different things, change: ‘field’ => ‘slug’, with ‘field’ => ‘id’, in your tax_query.
Yes, it behaves weird. No, shoot me, I can’t get a fix on precisely why and how (stacked joins are probably it). I say flip it. The only posts you don’t want to see are those with true custom key. Query for their IDs separately, feed result into post__not_in, ditch this meta query entirely.
The problem It looks like you are saving the data as: $a = array( “13112” ); update_post_meta( $post_id, “article_author”, $a); where this will give you the meta_value a:1:{i:0;s:5:”13112″;} Your first query will give you escaped quotes: LIKE ‘%\”13112\”%’ Method 1 If you save the author array with numbers instead: $a = array( 13112 ); update_post_meta( … Read more
Normally you would just specify a meta_value, e.g.: $args = array( ‘post_type’ => ‘business’, ‘meta_query’ => array( array( ‘key’ => ‘specials’, ‘value’ => ‘these are not the specials you are looking for – Obi Wan Kenobi’ ) ) ); However because your post meta is actually a data structure, a serialised PHP array/object, that’s not … Read more
There is no need to craft a custom SQL query in order to achieve this. Since version 4.1, WordPress’s query classes have supported complex/nested meta queries. So you can craft a query like this: $args[‘meta_query’] = array( // Use an OR relationship between the query in this array and the one in // the next … Read more
Multiple meta values can be compared with BETWEEN with an array value: ‘meta_query’ => array( array( ‘key’ => REALIA_PROPERTY_PREFIX .’attributes_area’, ‘value’ => array( $first_val, $second_val ), ‘type’ => ‘numeric’, ‘compare’ => ‘BETWEEN’, ), // inner array. ), // outer array. You can see this in Developer Doc.