Add custom field (value) to search result (without plugin)

WordPress search in posts table. You must change the search query by adding a postmeta table (with LEFT JOIN) and then add your own conditions to WHERE clause. 

<?php
/**
 * Extend WordPress search to include custom fields
 *
 * https://adambalee.com
 */

/**
 * Join posts and postmeta tables
 *
 * http://codex.wordpress.org/Plugin_API/Filter_Reference/posts_join
 */
function cf_search_join( $join ) {
    global $wpdb;

    if ( is_search() ) {    
        $join .=' LEFT JOIN '.$wpdb->postmeta. ' ON '. $wpdb->posts . '.ID = ' . $wpdb->postmeta . '.post_id ';
    }
    return $join;
}
add_filter('posts_join', 'cf_search_join' );

/**
 * Modify the search query with posts_where
 *
 * http://codex.wordpress.org/Plugin_API/Filter_Reference/posts_where
 */
function cf_search_where( $where ) {
    global $pagenow, $wpdb;

    $key_fields = array ( 'buty' );
    if ( is_search() ) 
        $where = preg_replace(
            "/\(\s*".$wpdb->posts.".post_title\s+LIKE\s*(\'[^\']+\')\s*\)/",
            "(".$wpdb->posts.".post_title LIKE $1) OR ("
                 .$wpdb->postmeta. ".meta_value LIKE $1 AND "
                 .$wpdb->postmeta. ".meta_key IN ('" .implode("','", $key_fields). "') )", $where );
    }

    return $where;
}
add_filter( 'posts_where', 'cf_search_where' );

/**
 * Prevent duplicates
 *
 * http://codex.wordpress.org/Plugin_API/Filter_Reference/posts_distinct
 */
function cf_search_distinct( $where ) {
    global $wpdb;

    if ( is_search() ) {
        return "DISTINCT";
    }

    return $where;
}
add_filter( 'posts_distinct', 'cf_search_distinct' );

Details can be found here “Search WordPress by Custom Fields without a Plugin”

Related Posts:

  1. Search ONLY by meta key / meta values
  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. Custom Fields Not in Search Results
  26. How make a custom search on backend in WordPress without plugin?
  27. filtering custom post types via meta data drop down
  28. Advanced search by two criteria – sort by location and date (ascending or descending)
  29. How do I have WP_Query match posts based on search parameter OR meta fields? (rather than search parameters AND meta fields)?
  30. 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
  31. Advanced search for meta fields
  32. Merge Multiple Custom Fields into one New Custom Field for Searching
  33. Change the main loop WordPress impact on the server?
  34. Removing “s” from search with custom parameters
  35. How to populate custom field dropdown box based on prior selection?
  36. Search in Archive Pages by subcategory, tag, custom field and year
  37. Custom WP_Query for WordPress Search Results with meta_query
  38. filter custom field values $min $max
  39. Restrict WordPress Search to Custom Field
  40. How can you include custom post meta in search without calling each key?
  41. pre_get_posts : only get posts by wp_usermeta value
  42. How to use pre_get_posts to alter posts_per_page of category pages, where ‘posts_per_page’ will be dynamic
  43. Modify date query by URL parameter using pre_get_posts and $_GET
  44. Include one custom field in search results
  45. Custom search SQL Query to add custom field in result
  46. Search Results Page – Displaying Custom Meta Fields
  47. Custom field Search with Relavanssi
  48. How to exclude custom fields from search queries?
  49. How to show content of custom fields in search results?
  50. Searching with Multiple (Parallel) Criteria on Custom Fields?
  51. Need to search a custom field (ingredients, one long string per post), but want it to allow phrases/non-exact matches
  52. Type character in name and make it invisble
  53. Search & column order by meta value in admin
  54. Woocommerce products search with custom fields
  55. Setting user permissions per post
  56. search based on custom field
  57. Very large list of options for BuddyPress profile fields
  58. searching by keywords in post’s metas or pagination links problem
  59. Search fails when using the radio buttons
  60. Admin – Search Events by a custom field
  61. Search one custom field?
  62. Create custom query for search?
  63. Query postmeta values, and return multiple post_titles for common meta value
  64. Query Custom Fields in Searchform
  65. Help sorting by Meta Key value
  66. Custom search with meta fields
  67. Using pre_get_posts to rewrite search query to display posts from multiple taxonomies
  68. Making a configurable field translatable
  69. importing data from non-wordpress mysql db
  70. How Do I Use WP_Query to Run This Database Query as Search Result?
  71. Use WP 3.1 Internal Linking ‘widget’ as a meta_box
  72. Comments form custom fields order
  73. how to save multiple custom fields for a post in one go?
  74. ACF won’t load from a custom JSON location
  75. Custom User Profile Fields
  76. Custom search for custom post meta with pre_get_posts interferes with WP search
  77. How to check for specific meta box value on front end and output accordingly
  78. Loop to display random posts only if a custom field matches category
  79. WP Query Returning All Posts
  80. WordPress User Profile Upload – If page is saved file reset
  81. How to add field above password section in profile page
  82. How do i save and retrieve custom attachment meta?
  83. Show values of dynamically created custom meta keys
  84. List taxonomy term “Last Name” + “First Name” (taxonomy custom field) in a post loop
  85. Filter by custom field (meta_key) using JSON API
  86. querying a custom field
  87. meta_value and meta_key filtering returning no posts [closed]
  88. Woocommerce Retrieving custom field value from orders
  89. If one meta key value is empty, try to get another meta key, and if both meta keys are empty show something else?
  90. How to order posts by number of Vimeo Likes
  91. Displaying a video on the homepage via a custom field inside a php widget
  92. how to create meta key name in wp_usermeta table in database
  93. Display the output from Custom User Fields from a WordPress user profile on a WordPress Custom Page
  94. get_field values for each post on home page using wp_add_inline_style
  95. Is there a way to determine which user changed a custom field (and when)?
  96. Show echo ready in single.php
  97. Save, update, get and sanitize post meta as HTML not plain
  98. Order categories by sum of custom fields
  99. added a meta box to post however when saving menu while debug on throws a warning
  100. How can i get the actor birthday by date?

Leave a Comment