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
- get custom post type by tag
- Query WooCommerce orders where meta data does not exist
- Finding all results from database within 500 miles of the given latitude and longitude [closed]
- Show only oldest post by author
- Dynamically Override Fancy Title – Part II
- Woocommerce custom loop to show all the products [closed]
- Get the post permalink within the loop but without additional DB query
- List the 5 most recent child pages
- Why does the_content not work like others for a set post id?
- Pagination is broken and I need help fixing it
- Query total number of posts
- Creating a custom search for a specific post type
- Loop returning only 1 result
- Query posts intersecting tags and categories
- Excluding pages in WP_query using ACF
- reset to main loop doesnt work
- Stuck in the query loop
- Query Page Content From Theme Options?
- How to display the featured image for each post?
- Check for the main query from the template
- Inner join overrides Advanced Custom Fields plugin’s get_field [closed]
- How to make posts unqueryable/unpublish posts where ACF relationship field is an unpublished post? [closed]
- how to get Nearby zipcode
- Get all posts with empty meta_value
- Loop 3 posts column wise and continue the loop into same columns
- Is it possible to retrieve posts depending on meta_key LIKE condition? [duplicate]
- How to Order By Two Custom Fields?
- Display specific page (that is child) content on parent page
- WP_User_Query orderby meta_val_num
- Query Taxonomy By Page Title
- WP_Query custom order and pagination
- Unable to paginate a custom page query
- How to change the default post type over the loop?
- Query Not working as expected
- Determine if ID is page or post and query the ID
- get_children() Archive Template
- Populate select list with meta values from all posts of a Custom Post Type
- Exclude post from wp_query based on custom field boolean
- show most viewed post
- Bootstrap grid while loop
- Order posts by tags count?
- Display posts side by side with custom query
- Is there a way to control both Order By and Order query parameters from one input field
- I need query_posts() to order results first by a meta value and then by post ID
- Search has query that will return no results
- WP Query – Search in title or author_name
- URL to Post Archive of Custom Query
- Some doubts about how the main query and the custom query works in this custom theme?
- orderby in WP_QUERY – Use the order from the Dashboard
- Random posts in WP_Query when searching by tag
- Pagination returns 404 after page 20
- Load 3 posts in flexslider slide [closed]
- Issue with WP_Query (need a array of selected ID’s)
- Advanced Post Display/Pagination/Ordering
- Combine privileged users array with my current query
- How to exclude posts ordered by comment_count from subsequent wordpress loops using WP_Query?
- Multiple loop for “featured” items returns wrong posts
- Get WP_Query query after execution?
- Pagination in custom query not working [duplicate]
- How to write a query-function as a query-shortcode?