[GENERAL] Searching a DB index.. possible?

2010-02-05 Thread Moe
I am trying to figure out how I can introduce full text search "tips"... tips meaning, like if you start typing Mer .. then a box with a couple of words underneath comes up, with *Mercedes, Mercury *and so on :P I am thinking that the word suggestions needs to come from the already existing tsearc

Re: [GENERAL] Searching a DB index.. possible?

2010-02-11 Thread Moe
Bump On Fri, Feb 5, 2010 at 5:48 PM, Moe wrote: > I am trying to figure out how I can introduce full text search "tips"... > tips meaning, like if you start typing Mer .. > then a box with a couple of words underneath comes up, with *Mercedes, > Mercury *and so on :P > > I am thinking that the w

Re: [GENERAL] Searching a DB index.. possible?

2010-02-11 Thread Richard Huxton
On 05/02/10 15:48, Moe wrote: I am trying to figure out how I can introduce full text search "tips"... tips meaning, like if you start typing Mer .. then a box with a couple of words underneath comes up, with *Mercedes, Mercury *and so on :P I am thinking that the word suggestions needs to come

Re: [GENERAL] Searching a DB index.. possible?

2010-02-11 Thread Moe
On Thu, Feb 11, 2010 at 6:56 PM, Richard Huxton wrote: > On 05/02/10 15:48, Moe wrote: > >> I am trying to figure out how I can introduce full text search "tips"... >> tips meaning, like if you start typing Mer .. >> then a box with a couple of words underneath comes up, with *Mercedes, >> Mercur

Re: [GENERAL] Searching a DB index.. possible?

2010-02-11 Thread Richard Huxton
On 11/02/10 17:11, Moe wrote: You might want to summarize down to a separate (word,frequency) table. Particularly if you don't want stemming to interfere with your suggestions. Stemming is ok. That's fine. How would this normally be implemented? Should I go through my text word by word myself