MySQL Forums
Forum List  »  Full-Text Search

Re: Match a List Table against an Alias Table
Posted by: Rick James
Date: August 04, 2010 10:13PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Match a List Table against an Alias Table
1981
August 04, 2010 10:13PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.