MySQL Forums
Forum List  »  Full-Text Search

Multiple keywords searched dynamiccly
Posted by: Erik Rooijmans
Date: August 03, 2010 07:16AM

Hi All,

Having a problem here.
Suppose I have a table book with columns : ID, Title.
I have another table subject with columns :

ID, code, keywords.
1, Animals, Dog
2. Animals, Cat
3. Animals, Snake
4. Animals, Horse
5. Cars, BMW
6. Cars, Mercedes
7. Cars, Volkswagen

I want to full text query the book table title column with for example all animals (that are known in the subject table matching animals)
So the full text query should match against Dog or Snake or Cat or Horse.
So basiccly I want to look up in the subject table all the keywords that should be used in full text query?

(Ofcourse when the table is updated with 8. Animals, Cow, the fulltext query executed would be also with Cow next time.)

Am I making myself clear?
Please let me know if not,

Can anybody help me achieving this?

Options: ReplyQuote

Written By
Multiple keywords searched dynamiccly
August 03, 2010 07:16AM

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.