Check the Codex. meta_query accepts an EXISTS comparison.
$args = array(
'post_type' => 'somepostype',
'meta_query' => array(
array(
'key' => 'fname'.$userid,
'compare' => 'EXISTS',
),
array(
'key' => 'lname'.$userid,
'compare' => 'EXISTS',
)
)
);
$query = new WP_Query( $args );
return $tempquery->found_posts;
There is a note that…
Note: Due to bug #23268, value is required for
NOT EXISTScomparisons
to work correctly. You must supply some string for the value parameter
– Note: empty string or NULL do NOT work. However, any other string will do the trick and will NOT show up in your SQL when usingNOT EXISTS.
It sounds as though EXISTS is not effected but I have not tested that. However, you may need to add a placeholder value if that still doesn’t work.
Related Posts:
- WP Query Args – Title or Meta Value
- Meta query with string starting like pattern
- how to show posts that are missing a meta_value
- Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
- Does tax_query really beats meta_query in all situations?
- Query WooCommerce orders where meta data does not exist
- Execute a large WP_Query with many “AND” Meta_Queries?
- Query all posts where meta value is empty
- WP_Query min and max values
- WP_Query using meta_query with relation OR and orderby meta_value doesn’t work
- querying with custom meta field with meta_query
- Order by two meta keys
- multiple meta key but get server load is very high
- A WP_Query that will look for posts after 2 weeks ago OR with a certain meta value
- Order by meta_value_num DESC and meta_value ASC on WP 4.0
- Finding all results from database within 500 miles of the given latitude and longitude [closed]
- WordPress altering my custom query, How to fix it?
- Use meta_query to display events by date in custom field
- Meta-value query
- Meta query field order together with post_date order causes posts without the meta field to be unordered
- How to show recent and upcoming birthdays using meta_query
- pre_get_posts filter meta_query without conflicting existing meta_query
- Undefined property: WP_Query::$post
- Programmatically set ‘meta_query’ for filter
- Using WP_Query and WP_Meta_Query Outside of WordPress
- If two first numbers exist in wp_meta_query value
- WP_Query meta_query >= date
- Extending woocommerce admin product search
- WP_Query on custom field and order results
- Complex Orderby Parameters: How to query with multiple orderby parameters using meta_value_num?
- Tax query clause inside a meta query clause?
- Adding an array from a query string to a WP meta_query
- Query multiple meta values
- Optional Meta Query
- Query by multiple meta elements not seeming to work – wordpress is timing out
- How do I make a meta_query OR relation work? [closed]
- Meta_query on same meta key, with diffrenct values
- Can we return all category (not post) with Custom Query Filter? [closed]
- Extend product search with meta in WooCommerce
- How does one perform a sub query with different post types
- how to make members list directory through wordpress post custom meta key.
- meta_value_num not ordering all items
- WP_Query with meta_query dosen’t return results
- meta_compare not comparing whole integer
- meta queries do ‘either/or’ checks
- WP Query ordering on a meta field for posts with a date in the future not ordering by datetime
- Is this meta query problematic?
- Selecting posts with a given meta value for a meta key
- Appending to existing WP_Query’s meta_query if exists
- Get every post with value in meta key
- get_page meta query not working, maybe a bug?
- Get meta_value of a specific meta_key from all posts belonging to a specific custom type
- Custom query filter by ACF date custom field
- Query by date from custom field
- Is it possible to retrieve posts depending on meta_key LIKE condition? [duplicate]
- Nested array issue in meta_query
- Error in meta_query not get result
- Comparing 2 Decimal Numbers from custom fields and displaying posts
- How to get current page nearest parent id?
- meta_query with array as value with multiple arrays
- Why doesn’t my WP Meta Query return any results?
- Sort posts using multiple custom fields and menu_order in single query?
- Order (by ASC) posts with meta_key so posts without values are last
- Search filter between promo and exact price
- meta_query – check for multiple meta values in key which holds an array of values
- WordPress Meta Query Null Values Order
- show most viewed post
- Searching for a specific month in a metadata saved as Timestamp (Wp_Query)
- Why can my filter query SOME metadata but not other metadata?
- Getting posts by custom field value
- WP_Query on custom key and value
- Get posts having meta value between two numbers
- wordpress multiple meta value query is not working
- Strange results from WP_Query
- How to set meta_query if get_post_meta returns nested array for that key? [duplicate]
- Pre get posts sort by meta key returns no results if meta key does not exist
- Sorting with meta_query and multiple, optional meta keys
- meta_query with relation = AND not working as expected when combining EQUALS with NOT EQUALS
- WP Query for Multiple Post Types
- Query by meta value (add a dropdown of all values)
- Order Posts By Custom Field That is an array of objects
- Orderby query does not work for custom fields even with meta query
- Query custom meta value – post view and date meta
- make query more simplest and in one query
- WP_Query returns empty if meta_query has more than 7 values
- Use not custom fields in get_posts() meta_query?
- Compare meta key separation
- WordPress meta_query not working
- Using orderby with 2 meta keys
- Passing conditional arrays to WP_Query() [closed]
- WordPress Query Default Order if Meta Values Same?
- Custom query (author is post_author or meta co_author) with Pagenavi pagination
- 294 Queries on Mainpage of WordPress
- How to get all post_id and meta_value using meta_key in wp_postmeta table
- WP Query – Show custom posts only if user contain some user meta
- How do I subquery with custom meta fields?
- get_post_meta bringing back results, but $wpdb->postmeta doesn’t
- Showing Counts on Comment List with Custom Query
- Custom query with custom filtering returning incorrect results
- How to get products with the same custom attribute like ean code