/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

5 votes386 views1 answer
Debug wordpress errors
PHP Wordpress
15 votes431 views4 answers
Wordpress thumbnail url
PHP Wordpress
7 votes375 views3 answers
Wordpress custom loop
PHP Wordpress
0 vote455 views1 answer
Définir un nombre maximum de mots sur les titres des publications WordPress
PHP Wordpress
0 vote298 views1 answer
Wordpress create post programmatically
PHP Wordpress
0 vote356 views1 answer
Wordpress html classes
PHP Wordpress
0 vote360 views1 answer
Remove autoupdate wordpress
PHP Wordpress
10 votes384 views4 answers
Error_log wordpress
PHP Wordpress
1 vote373 views1 answer
Wordpress convert non negative
PHP Wordpress
0 vote351 views1 answer
White labeling wordpress divi
PHP Wordpress