MySQL Forums
Forum List  »  Newbie

How to use Full Text search to find 1000 product names in a 400K product catalog
Posted by: Kiran Bellare
Date: January 17, 2009 04:13AM

I'm have 2 tables containing product info from 2 different sources (1 is 1000 top-selling products and the other is 400K products from various catalog).

i'm to find the 1000 products in the 400K product catalog by using full text search to match the product names, and spit out a table containing the matches. (Product names aren't an exact match)

PLEASE HELP - I'm struggling with the SELECT statement, because
1) i don't know how to loop across the 1000 products. The full-text-search needs a CONSTANT in the AGAINST argument - how do i feed it with the product name, which is another table.
2) how to pipe the output to a csv file or a table, so i can get a dump of it?

The query i'm using is

SELECT product_feed.*, top_products.name.* WHERE MATCH(product_feed.name) AGAINST (top_products.name) Having rel>.8;

Note i'm using a high relevance threshold, so that i don't get too many matches that i'll have a hard time filtering.

Examples of product names are -
- Unicure Generic Cialis, Tadalafil 20 Mg 90 Pill 18 Free Pill
- Philips 1050CC
- Omron Omron HEM 650 Wrist Blood Pressure Monitor with A.P.S
- Unicure Viagra 30 Pills 100mg Each
- Clarisonic Clarisonic Skin Care Brush
- Braun Braun Oral B Professionalcare 9400 Triumph, D255264
- Johnson & Johnson Acuvue 2 Contact Lenses
- Sonicare Sonicare Elite E9500 Electronic Toothbrush

Options: ReplyQuote


Subject
Written By
Posted
How to use Full Text search to find 1000 product names in a 400K product catalog
January 17, 2009 04:13AM


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.