MySQL Forums
Forum List  »  Full-Text Search

full text search against multiple tables
Posted by: Tony Qian
Date: March 26, 2006 12:10AM

I have a situation which needs to search multiple tables:

Let's say I have category, brand, and coupon tables.

category {category_id, category_name}
brand {brand_id, brand_name}
coupon {coupon_id, category_id, brand_id, coupon_detail}

my question is how to do a full text search if user just enters several words to search coupons. the words could be category name, brand name or words in coupon_details. The difficulty is you don't know which word is category name, which word is brand name. The words user entered might not contain category name or brand name.

any suggestions? does MySql full text search really supports multiple table search?


Options: ReplyQuote

Written By
full text search against multiple tables
March 26, 2006 12:10AM

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.