mysql – FacetWP – Exclude ‘The’ and order list alphabetically

I have a list of companies that are pulled from Salesforce database into WordPress, its alphabetized and set with FacetWP plugin. With it, companies that start with ‘The’ are listed under T. For example, if company name is The Best – its listed under T but I need it to ignore ‘the’ and display under B.

I tried this:


if ( 'alpha' == $params('facet_name') ) {

    $params('facet_value') = $params('facet_display_value') = trim( str_replace( 'The ', '', $params('facet_display_value') ) );

}

return $params;

}, 10, 2 ); 

What this has done is, list company under correct letter, but it kept ‘The’ and listed the company at the very bottom of the list instead of where it should be alphabetically.

For example:

Bar
Bergen
Buster
The Baby
The Best

What I need it to do instead, is remove ‘The’ and place company in proper alphabetical order like so:

Baby
Bar
Bergen
Best
Buster

Did anyone run into the similar problem and managed to solve it?

Thanks so much in advance!