MySQL Forums
Forum List  »  Full-Text Search

full text query on lookup table
Posted by: Erik Rooijmans
Date: August 05, 2010 01:46AM

Hi All,

Question here about the following problem:

I have a table books:

ID | Title | Category
----------------------
1 bla Animal
2 blah Animal
3 blahbl Animal

And a table types:

ID |Type |Keyword
-------------------
1 Animal Dog
2 Animal Cat
3 Animal Cow
4 Animal Snake
5 Car Volkswagen
6 Car Mercedes

I would like to have a full text query against animal on the table books that actually need to looks up all the keywords specified in the table types.
So If I would start searching for anmials the full text query would be: select ... where match against ('Dog', 'Cat', (all the animals listed in the type table).
If I would add another animal in the type table this would be used in the next query.

Is there any way to achieve this?

Thanks

Erik

Options: ReplyQuote


Subject
Views
Written By
Posted
full text query on lookup table
6692
August 05, 2010 01:46AM
2349
August 07, 2010 12:09PM
2242
August 11, 2010 01:52AM
2088
August 11, 2010 01:56AM
2402
August 12, 2010 07:46AM


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.