Re: Match a List Table against an Alias Table

[Rick James]

Don't use columns, use rows:

CREATE TABLE Aliases (
   company_id INT ...,
   alias VARCHAR(...) ...,
   PRIMARY KEY (company_id, alias),
   INDEX(alias)
);

There will be 7 rows in that table for HP. Some companies might have only one row.

You might have two companies with the same alias. Have you pondered what to do in that case? At least, this table gets you started.