If you store the meta as a serialized array, you should do meta query like this:
$args = array(
'post_type' => 'income',
'meta_query' => array(
array(
'key' => 'income_dates',
'value' => "2014-02-01",
'compare' => 'LIKE'
),
)
);
Related Posts:
- meta_query on a date range using an array of values
- Return only Count from a wp_query request?
- WP_Query vs get_posts
- Usage of the new “posts_clauses” filter in WordPress 3.1?
- WP_Query: query posts by ids from array?
- pre_get_posts with get_posts
- Query Custom Meta Value with Increment
- Identify which loop you are hooking into; primary or secondary?
- SQL query equivalent to WP User Query
- Transient pagination not working properly
- How to speed up wp_query, took more 5s to run against 100k posts
- Splitting the main query in multiple loops with query_posts and/or pre_get_posts?
- Undefined WP_Query::has_posts()?
- Create ONE callback for all page templates, post filter queries + paginated pages, triggering pagination via AJAX
- if/else on custom query gives 200 OK when condition not met?
- How to find exact match for search term in WP_Query? What is the additional string added in LIKE query in WP_Query?
- Order by summing multiple values
- Order by empty custom field
- Check if loop has any categories?
- How to get list of posts from permalinks?
- Is_single() conditional tag returns null in query
- Transient api Caches confused
- Include current post into loop
- Should I reset $wp_query?
- How to filter query loop block with a search string from the query parameters
- Update query for wp_posts and wp_postmeta
- mysql query order by
- I am officially missing something about transient posts
- Woocommerce Get Orders By Meta Value
- WP_Query & Duplicate entries
- how to show more than 1 post into three columns query
- Ordering Posts by parent category, name ascending
- WP_Query always returning the last custom post
- WP_Query secondary query failing
- Loop through multiple custom fields with increasing number
- Get a list of the last posts grouped by author and filtered by category
- Parsing External Table Arguments
- WordPress query very slow on +/- 300k DB entries and 7 INNER JOIN
- Main loop querying current template’s info only in custom category archive pages, not my posts
- Woocommerce set loop_shop_columns to be 3 in the main shop page loop only and 4 otherwise
- Multiple queries and pagination
- Order by DESC, ASC in custom WP_Query
- Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
- How to make an activities stream mixing posts and comments?
- How to query for a week using key => value WP_Query argument notation?
- Sort posts by custom taxonomy name
- Looping through tabular data
- Would this post meta be better added to the post table rather than post_meta table
- Show default content if custom WP_Query has no posts
- How to prevent writing duplicate loops?
- Pass array of taxonomy terms to wp_query
- merge two query arguments into one WP_Query call
- Using WP_Query in “parse_query” or “pre_get_post” in Posts2Posts
- How to reduce the number of queries?
- why update and delete query not worked in custom table?
- List of the years with posts presented
- Query custom post type by custom taxonomy (category slug)
- Editing the default wordpress search
- Weird orderby => post__in issue
- Slow page loads due to WordPress Core Query
- 1/3 of posts different class
- Better wordpress attachment query than this
- How do I rewrite this loop as a new WP_Query style-loop?
- Is it possible to query from external database? [duplicate]
- Can’t sort custom post type by random
- How to add div blocks after certain set of post
- Trying to retrieve random post, getting a page
- Exclude taxonomy term from all loops, but having it on widget
- PHP – Loop custom post type categories within jQuery Tabs
- Ordering posts by custom field and grouped by month
- relation OR instead of AND – Filtered term ID’s in loop
- Compare “Main” post ID to ID inside wp_query loop
- problem with the loop
- Multi-layered WP_Query
- `offset` WP_Query argument dont work via `pre_get_posts`
- Function the_posts_pagination() not compatible with WP_Query arguments
- SQL query injection with fifu image
- Pagination of custom page with custom fields query
- How to show specify category template for both parent and child category
- Woocommerce featured products query no longer working
- WordPress Query optimaization for slow query
- Meta query doesn’t remove placeholder escape before query
- Query doesn’t display text data with apostrophes
- query all posts published by certain user id
- modifying the loop multiple times with arguments passed through ajax to wp_query
- WP_Query causing links to not work
- Iterate through ID’s in loop
- An archive page without post format (just standard post)
- How to organize a WP_Query’s list of posts by category and display category title?
- Need help setting up a search form for wordpress [duplicate]
- Converting an existing query_posts to WP_Query
- WordPress Query showing multiple titles
- Loop being strainge
- Problem with WP_Query sort
- Get author meta data with no published posts in author.php?
- Print post data inside loop using theme content template
- Prevent WordPress loop from displaying similar post titles
- Custom WordPress loop, articles not in same order as Array
- Modify WordPress Search
- $wp_query->found_posts; returns zero