MySQL Forums
Forum List  »  General

Fulltext search and join ?
Posted by: Mario Neto
Date: November 25, 2004 10:45PM

Hi, I am confused with a fulltext search I'd like to do.

I have three tables that contains information about products (price, descriptions, details etc) and I'd like to make a search using fulltext indexes. They all have one common column which is the productId.

Basically I'd like to show products that contain (match) one (or more) of the keywords the user informs.

All examples I've found only matches one table.

Thanks.

Options: ReplyQuote


Subject
Written By
Posted
Fulltext search and join ?
November 25, 2004 10:45PM
November 29, 2004 05:47PM


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.