MySQL Forums
Forum List  »  Full-Text Search

Re: Phrase searching
Posted by: Apachez
Date: August 22, 2006 03:31AM

One method might be to use windowing. Like having a window over your text in this case take the word 2 and 2.

Example:

docid:1 ->
someone bought a plasma tv on vacation

ends up into:

1. someone bought, 1
2. bought a, 1
3. a plasma, 1
4. plasma tv, 1
5. tv on, 1
6. on vacation, 1

When you then search for the phrase "plasma tv" you will get a hit at row 4 which tells you that docid 1 has this phrase.

Problem with this method is that it will take some space on disk but also you need to decide how large phrase will be allowed (2 words or 3 words or even more?).

Perhaps someone else might have ideas on how to store and then search for phrases efficiently if we limit to use mysql without modifications as storage?

Options: ReplyQuote


Subject
Views
Written By
Posted
3587
August 10, 2006 06:04AM
Re: Phrase searching
2125
August 22, 2006 03:31AM


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.