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

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 );