MySQL Forums
Forum List  »  Full-Text Search

Reverse lookup using full-text
Posted by: Jasper Hammink
Date: March 05, 2007 02:46PM

I have been looking for functionality to do a reverse lookup using full-text search. That is, I want to perform a query like
SELECT * FROM TABLE1 WHERE MATCH('My Item') AGAINST (item IN BOOLEAN MODE);
where the item column contains values like '+my +item'.
So instead of finding all text records that match a full-text search term, I would like to find all full-text records whose content match a search term when interpreted as a full-text search criterium.
Does anybody know if this is possible at all, or if it would be possible using the new custom parser functionality? Or would there be any other way to recognize a text record from a set of full-text criteria?

Thanks,
Jasper

Options: ReplyQuote


Subject
Views
Written By
Posted
Reverse lookup using full-text
4357
March 05, 2007 02:46PM


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.