add_filter( 'posts_join', function( $join ) {
global $wpdb;
return is_search()
? sprintf(
'%s LEFT JOIN %s ON %s.ID = %s.post_id ',
$join,
$wpdb->postmeta,
$wpdb->posts,
$wpdb->postmeta
)
: $join;
} );
add_filter( 'posts_where', function( $where ) {
global $pagenow, $wpdb;
return is_search()
? preg_replace(
"/\(\s*" . $wpdb->posts . ".post_title\s+LIKE\s*(\'[^\']+\')\s*\)/",
"(" . $wpdb->posts . ".post_title LIKE $1) OR (" . $wpdb->postmeta . ".meta_value LIKE $1)",
$where
)
: $where;
} );
add_filter( 'posts_distinct', function( $where ) {
global $wpdb;
return is_search() ? 'DISTINCT' : $where;
} );
Site search include all postmeta
See: https://adambalee.com/search-wordpress-by-custom-fields-without-a-plugin/
How to use
- Log into a staging, development, or locally hosted clone of your site
- Install and activate Code Snippets
- WP Admin > Snippets > Add New
- Copy and paste the code from the Description tab above
- Check to ensure formatting came over properly and no syntax errors show up in the editor
- Customize the code as desired
- Add a meaningful title
- Select whether to run on front-end or back-end (or both)
- Click “Save and Activate”
- Test your site to ensure it works
- Disable if any problems, or recover
- Repeat for live environment
License
All code snippets are licensed GPLv2 (or later) matching WordPress licensing.
Disclaimer of warranty:
Except when otherwise stated in writing the copyright holders and/or other parties provide the program as-is without warranty of any kind, either expressed or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose.
Support
- Describe the issue and what you’ve observed.
- Describe your expected outcome(s).
- List steps to reproduce the issue.
- Optionally provide screen-shot or video URLs.
- Email to [email protected]
Partners
