MySQL Forums
Forum List  »  Newbie

Good non-exact matching approach?
Posted by: Hewitt Cai
Date: April 06, 2023 07:21AM

I have been playing around the non-exact match. Recently I am having this problem.

Here is a list of company names:

1, Apple Inc
2, Apple Design Inc
3, Apple Cell Inc
4, Apple Pod Inc
5, Apple Fruit Inc
6, Apple Drink Inc
7, Apple Juice Inc

1-4 are the ones I want to get from matching because they are all related to Apple Inc ´╝łApple Inc is the parent and the rest are the subsidiaries). If I use "Apple" word to do the non-exact match, I believe I will get all 7, and 5-7 are companies not related to Apple Inc. Is there any good non-exact matching approach so eventually I can get 1-4, not 5-7?

Thank you all!

Options: ReplyQuote


Subject
Written By
Posted
Good non-exact matching approach?
April 06, 2023 07:21AM


Sorry, only registered users may post in this forum.

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.