Autocomplete facet return only results matching the exact value entered in FacetWP

[sebastian-moran]

Autocomplete facet return only results matching the exact value entered in FacetWP on child sites.

Snippet Type

Execute on Child Sites

Snippet

add_filter( 'facetwp_wpdb_sql', function( $sql, $facet ) {

  if ( 'my_autocomplete' == $facet['name'] ) { // Replace 'my_autocomplete' with the name of your Autocomplete facet
    global $wpdb;
    $sql = $wpdb->remove_placeholder_escape( $sql );
    $sql = str_replace(" LIKE '", " = '", $sql);
    $sql = str_replace("%", "", $sql);
  }

  return $sql;
}, 10, 2 );