MySQL Forums
Forum List  »  General

Re: Fulltext search and join ?
Posted by: Vijay Nukala
Date: November 29, 2004 05:47PM

select * from price,descriptions,details where price.id=descriptions.id and price.id=details.id and match(description.description_col_name) against ('key words') and match(details.details_col_name) against ('key words')

hope that helps.

Vijay

Options: ReplyQuote


Subject
Written By
Posted
November 25, 2004 10:45PM
Re: Fulltext search and join ?
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.