/PHP/Wordpress/Search WordPress with custom field

Search WordPress with custom field

function me_search_query( $query ) {
  if ( $query->is_search ) {
    $meta_query_args = array(
      array(
        'key' => 'your_key',
        'value' => $query->query_vars['s'],
        'compare' => 'LIKE',
      ),
    );
    $query->set('meta_query', $meta_query_args);
    add_filter( 'get_meta_sql', 'me_replace_and_with_or' );
  };
}

function me_replace_and_with_or( $sql ) {
    if ( 1 === strpos( $sql['where'], 'AND' ) ) {
        $sql['where'] = substr( $sql['where'], 4 );
        $sql['where'] = ' OR ' . $sql['where'];
    }

    //make sure that this filter will fire only once for the meta query
    remove_filter( 'get_meta_sql', 'me_replace_and_with_or' );
    return $sql;
}

add_filter( 'pre_get_posts', 'me_search_query');

Source: wordpress.stackexchange.com

Similar codes

2 votes253 views1 answer
Wordpress display all variables
PHP Wordpress
2 votes241 views2 answers
Wordpress is admin
PHP Wordpress
0 vote248 views1 answer
How to remove text tab in wordpress editor
PHP Wordpress
3 votes253 views1 answer
Debug graphql wordpress
PHP Wordpress
2 votes239 views3 answers
Wordpress get user id by email
PHP Wordpress
0 vote219 views1 answer
Wordpress add to cart redirect php
PHP Wordpress
0 vote240 views2 answers
Display category name wordpress
PHP Wordpress
0 vote253 views1 answer
Remove action from theme wordpress
PHP Wordpress
11 votes280 views3 answers
Define home url wordpress config.php
PHP Wordpress
0 vote240 views1 answer
Wp change num words exerpct
PHP Wordpress