Search ONLY by meta key / meta values

You could do two things:

A) replace the search with a SQL query that only searches the postmeta table (faster as there’s no JOIN involved – you can get the post via it’s ID later on, when displaying the results).

B) Split the string right after WHERE 1=1 and drop the later part. You can use a simple return str_replace( $query_part_below, '', $search );.

 AND (
    (whirl_2_posts.post_title LIKE '%__SEARCH_STRING__%')  
    OR (whirl_2_posts.post_content LIKE '%__SEARCH_STRING__%')
)

Make sure that you properly $wpdb->prepare() before pushing it back in.

Related Posts:

  1. Add custom field (value) to search result (without plugin)
  2. How to display search query as formatted text?
  3. Search for meta_query does not return any result if combined with title
  4. Using meta query (‘meta_query’) with a search query (‘s’)
  5. Can I exclude a post by meta key using pre_get_posts function?
  6. Including custom fields in search?
  7. Add custom fields to search
  8. Custom search: by post data and post metadata?
  9. Show only posts which can be commented OR have custom meta field
  10. Need small coding with Custom Fields Search
  11. Filter results with custom field values and dropdown
  12. Is there a way to do multiple ordering on a multiple meta_query?
  13. searching in custom meta field
  14. WordPress Search Custom Meta Field Only
  15. Exclude custom post type from search by custom field value?
  16. Setting orderby to a custom field using pre_get_posts
  17. Extend ‘The Events Calendar’ search to include custom fields [closed]
  18. Include woocommerce custom field value in front-end search result
  19. Including Database Generated Pages in Site Search [closed]
  20. Using more than one meta_key in pre_posts_query
  21. Adding Custom Fields to Search
  22. sort search results by custom fields using dropdown
  23. Using a checklist to search against metadata
  24. How do I use wp_query for WordPress search?
  25. Including Custom Meta with posts_where query
  26. Custom Fields Not in Search Results
  27. How make a custom search on backend in WordPress without plugin?
  28. filtering custom post types via meta data drop down
  29. Advanced search by two criteria – sort by location and date (ascending or descending)
  30. How do I have WP_Query match posts based on search parameter OR meta fields? (rather than search parameters AND meta fields)?
  31. Why the pagination for a query modified by pre_get_posts doesn’t mind the number & order of posts sorted & selected based on a custom date time field
  32. How do I hide posts across all loops based on the value of a custom field?
  33. Advanced search for meta fields
  34. Merge Multiple Custom Fields into one New Custom Field for Searching
  35. Change the main loop WordPress impact on the server?
  36. Removing “s” from search with custom parameters
  37. How to populate custom field dropdown box based on prior selection?
  38. Search in Archive Pages by subcategory, tag, custom field and year
  39. Custom WP_Query for WordPress Search Results with meta_query
  40. filter custom field values $min $max
  41. Restrict WordPress Search to Custom Field
  42. How can you include custom post meta in search without calling each key?
  43. pre_get_posts : only get posts by wp_usermeta value
  44. How to use pre_get_posts to alter posts_per_page of category pages, where ‘posts_per_page’ will be dynamic
  45. Modify date query by URL parameter using pre_get_posts and $_GET
  46. Include one custom field in search results
  47. Custom search SQL Query to add custom field in result
  48. Search Results Page – Displaying Custom Meta Fields
  49. Custom field Search with Relavanssi
  50. How to exclude custom fields from search queries?
  51. How to show content of custom fields in search results?
  52. Searching with Multiple (Parallel) Criteria on Custom Fields?
  53. Need to search a custom field (ingredients, one long string per post), but want it to allow phrases/non-exact matches
  54. Type character in name and make it invisble
  55. Search & column order by meta value in admin
  56. Woocommerce products search with custom fields
  57. Setting user permissions per post
  58. search based on custom field
  59. Very large list of options for BuddyPress profile fields
  60. searching by keywords in post’s metas or pagination links problem
  61. Search fails when using the radio buttons
  62. Admin – Search Events by a custom field
  63. Search one custom field?
  64. Create custom query for search?
  65. Query postmeta values, and return multiple post_titles for common meta value
  66. Query Custom Fields in Searchform
  67. Help sorting by Meta Key value
  68. Custom search with meta fields
  69. Sort posts by numeric value of custom field, and also show any other posts without that custom field
  70. Filtering output by two custom fields using posts_where and add_rewrite_rule
  71. Sort posts by numeric value of custom field, and also show any other posts without that custom field
  72. Search by Custom Field content OR post id via the WordPress Dashboard
  73. Get custom field from page, in a post?
  74. Echo text if field under user_meta is empty with get_users()
  75. Hard Define Custom Field Value
  76. Filtering posts by WORD in custom field
  77. Use Metabox to enter Post Title
  78. Parse Shortcodes in Theme’s Custom Field?
  79. Include custom fields into the content of a regular page
  80. Basics: adding template tag to display custom fields in the post
  81. Bypassing a Form Options
  82. Create widget that filters posts on current page based on entered value
  83. Undefined Variable (Displaying image via custom field)
  84. I would like to display different text on different pages
  85. Adding custom field to Lightbox in header only pulls current page data, not Lightbox item data
  86. Meta boxes not displayed, data isn’t being saved
  87. Exclude empty fields from custom field calculation (Average)
  88. Semi-Private Comments + page comments -> is it possible?
  89. Cannot get tags working from a WPAlchemy metabox with wp_editor()
  90. Alter SQL query to return posts with unique custom field value, no duplicate values
  91. show custom field content in jquery tabs
  92. custom field output after the_content
  93. How to create Parent-Child relation for custom fields?
  94. Custom fields / meta box output
  95. Create citation and url in post using 3 custom fields with conditions for each field… So close!
  96. How to organise via Custom Fields on Category Page
  97. How to query posts that have certain post meta keys, and sort by meta key and/or value
  98. Insert shortcode before and after a list automatically
  99. Calling Custom Field within Function wrapped with Divs.
  100. How to check if custom field exists in this widget query

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)