This is a symptom of having a %
character in your meta query value. Since 4.8.3 %
characters are being escaped (actually replaced by a semi random string) and should be unescaped before executing the sql query.
You should check with the plugin author what would be the best way to handle it, but in your specific case I would say that slight redesign to your code would be a better solution than any unescaping code. LIKE
is an expensive operation better be avoided and based on your UI you can just make a strict compare of values instead.
Related Posts:
- ACF Relationship Field Search Filtering [closed]
- ACF datepicker meta_query Compare Dates in m/d/Y g:i a – Not in Ymd Format
- meta_query with array as value
- If two first numbers exist in wp_meta_query value
- WP_Query meta_query >= date
- ACF Date Based wp_query
- Custom query based on meta key – Reduce three states to two in results?
- Any number in meta key (wp query)
- WP_Query with meta_query dosen’t return results
- Custom query filter by ACF date custom field
- Order WP_Query by meta_key priority when ‘OR’ relation used for multiple meta values
- ACF: How to query for a given value count of an array like field? (e.g.: How many rows has a `flexible_content` field?)
- WP_Query, ACF field and array
- Pre get posts sort by meta key returns no results if meta key does not exist
- Slow wp_posts and wp_postmeta query using Advance Custom Fields
- Get posts meta_query by repater field
- How can I modify standard search query to include also ACF custom fields values?
- The sorting of posts by a meta_query with two keys fails while separated as single queries it works
- Get posts using multiple values from ACF checkbox as meta query wordpress
- How do I subquery with custom meta fields?
- Use value from meta key array for use in WP_Query
- Meta_query compare operator explanation
- Nested meta_query with multiple relation keys
- meta_query ‘compare’ => ‘IN’ not working
- Sorting: custom query with orderby meta_value_num THEN by title
- Display List Of Posts Containing a Relationship Field Value [ACF]
- Using OR conditions in meta_query for query_posts argument
- WP_Query with checkbox meta_query
- Query Multiple Post types each with own meta query
- Meta Query with date and time on the same Day before given time
- How to grab metabox value in wp_query meta_query key
- How can I create a WP_Query that returns posts where one meta_value
- WP Meta Query for some meta (array) values
- How to count data records in wordpress which have same meta_value in wp_postmeta table?
- WP Query – Get WooCommerce Products with variation that is in stock
- Meta_query with or without value
- Query Posts depends on custom field inside repeater field using acf
- wp_query not searching with apostrophe
- Add condition of user capability in WP_query
- Performance when getting post meta for post retrieved by meta value
- Adding an array from a query string to a WP meta_query
- Query by multiple meta elements not seeming to work – wordpress is timing out
- How to display multiple custom fields with the same meta_key in an ascending order?
- Meta_query with multiple keys and multiple values
- How does one perform a sub query with different post types
- How to Union two different conditions in one WP_Query
- Tax query AND/OR meta query [duplicate]
- Help ordering Post loop by two meta values
- How to do a wp_query with two acf-fields, sorting on one of them
- Using Advanced Custom Field for file upload, how do I load the file url
- Multisite wp_query & switch_to_blog issue
- Stuck in the query loop
- Include post content of linked posts in search
- meta queries do ‘either/or’ checks
- How to make posts unqueryable/unpublish posts where ACF relationship field is an unpublished post? [closed]
- WP Query ordering on a meta field for posts with a date in the future not ordering by datetime
- Merge 2 custom post type posts and taxonomy terms and sort ascending
- Is this meta query problematic?
- JSON – Create rest api endpoint for Advanced Custom Fields
- 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
- Query by date from custom field
- Nested array issue in meta_query
- Error in meta_query not get result
- How to get current page nearest parent id?
- Using WP meta query to show custom post types by a start and finish date
- 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?
- Optimising WP_Query with ACF Fields
- WP_Query – display posts by custom field and order by another
- Order (by ASC) posts with meta_key so posts without values are last
- meta_query – check for multiple meta values in key which holds an array of values
- 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
- How to get taxonomy image attached to a Post Type WordPress
- 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]
- Sorting with meta_query and multiple, optional meta keys
- Query by meta value (add a dropdown of all values)
- Order Posts By Custom Field That is an array of objects
- ACF: using two loops, the_field returns field content from another loop
- Orderby query does not work for custom fields even with meta query
- WP_Query returns empty if meta_query has more than 7 values
- Use not custom fields in get_posts() meta_query?
- WordPress meta_query not working
- Using orderby with 2 meta keys
- Passing conditional arrays to WP_Query() [closed]
- Custom query (author is post_author or meta co_author) with Pagenavi pagination
- Display all custom meta field values from the database using ACF Repeater
- Get all user with both meta_value
- get_post_meta bringing back results, but $wpdb->postmeta doesn’t
- Custom query with custom filtering returning incorrect results
- Best performance for use Custom Field in WP