Seems I have an answer – it was how the SQL statement was setup.
$where .= " OR (( $wpdb->postmeta.meta_key = '$meta_key' AND (UPPER($wpdb->postmeta.meta_value) LIKE '%$meta_value%') ))";
Now is the field has the string “Whistler Bike Park, Canada” but the user only searches for “Whistler”, I get the post/s returned that I expect.
Related Posts:
- How to make search include data from wp_postmeta?
- Create multiple Search functions for posts / custom post types and everything
- How Do I Use WP_Query to Run This Database Query as Search Result?
- pre_get_posts and search query for admin
- Custom search for custom post meta with pre_get_posts interferes with WP search
- Search function works improperly
- Searching by meta values showing inappropriate result
- Force is_search to always TRUE
- How to conditionally pass a parameter to wordpress search to limit post types?
- How to make search include data from wp_postmeta?
- How to exclude pages from WP search based on page title
- Modifying post content with the_post action hook
- why pre_get_posts works fine in post type archive, but not in search result list?
- Search for two strings in WP search
- Displaying number of search results for each post type
- How to query two meta fields and display results between them
- Use pre_get_posts to display search results by meta in specific order
- meta post search
- Search custom posts by meta key in admin
- pre_get_posts improperly searching revisions
- search for single meta_key with numeric array of meta values
- WP search in metadata post
- Search for meta_query does not return any result if combined with title
- Search Filter by mime type not working in pre_get_posts
- search filter for search and tag page doesn’t work
- Consistent and Admissible Heuristics
- Solr vs. ElasticSearch
- How do you make Vim unhighlight what you searched for?
- grep for special characters in Unix
- Search is always exact [closed]
- Can I exclude a post by meta key using pre_get_posts function?
- Advanced search form with filters for custom taxonomies and custom fields
- how to limit search to post titles?
- How to create live autofill search?
- How can I implement a location based (zip code) search in WordPress?
- How to highlight search terms without plugin
- How do I remove Pages from search?
- Empty search returns home page, how to return not found search page?
- How to search for (partial match) display names of WordPress users?
- How does WordPress search work behind the scenes?
- Remove some pages from search
- Limit search to latin characters
- How to look at code in WordPress repositories without downloading?
- Extend WordPress search to include user search
- Display search results within the same page
- Empty search input returns all posts
- How can i move search results onto a specific page?
- Using pre_get_posts to rewrite search query to display posts from multiple taxonomies
- Remove meta robots tag from wp_head
- WordPress blog with 30 000 posts: poor search performance
- Custom search filter causes menu and query_posts problems
- Template issues getting ajax search results
- WordPress database error: [Not unique table/alias: ‘wp_postmeta’]
- Insert DIV container below 1st search result
- Unified search across separate WordPress installations
- Search in WordPress – Difference of searchpage.php, searchform.php and search.php?
- How to make WordPress search prioritise page titles?
- Reduce or prevent calling of update_meta_cache
- How to add the author search in the default wordpress search?
- Admin Area Custom Type Search By Meta Fields Without Title & Content
- How do I filter the search results order?
- How to insert a span inside a search form?
- How do I redirect /search/ to wordpress search template?
- How do I Paginate Search Results for Custom Post Types?
- Dealing with Many Meta Values, 30+
- How to search for users based on added user metadata
- Search by Post ID and display content of the post in search result
- Extending search query with additional $sentence value
- Link to search page without search parameter
- Order Search Results Page by meta_value If no Value Return Remaining Results
- Search/Replace for editor in HTML-mode
- How do I search events between two set dates inside WP?
- Search only blog posts (default WP search widget)
- Exclude pages from WordPress search result page
- How to pass a search $_GET parameter to a new custom search page?
- Do I need to sanitize WordPress search query?
- Disable Redirect to Product Page on Search Results Page in WooCommerce [closed]
- Search Using Post ID
- Search custom post type by meta data
- Neither the_excerpt() nor the_content() works properly?
- Let user change posts per page
- Search ONLY by meta key / meta values
- WP User Query with search columns and meta query
- Exclude top-level pages from search results
- WordPress 3.6, searchform.php problems
- Search in non-English language returns only one result
- Complex Search functionality. Advice needed
- Get user role by using user_id in buddypress
- How to use next_post_link and previous_post_link on single posts in search results
- Why is there a class=”screen-reader-text” on my search button?
- template_include for search.php makes WordPress think its on the home page
- Turning Broken URLs Into Search Terms?
- How can I implement faceted search with WordPress 3.x?
- can’t limit search to only pages
- Meta query interfering with orderby relevance
- Add custom field (value) to search result (without plugin)
- Add custom parameters to JSON API search query?
- Combining Meta_Query key values for one array
- Change the Search Base in a multi language wordpress
- Display posts from an author using search parameters (not author template/query_posts)