Subject Re: [firebird-support] google type search of a VARCHAR field
Author Mark Rotteveel
Firebird itself has nothing like this. You could look at Lucene, which
provides such functionality. My previous employer used Lucene (+ some
homewritten stuff) to create such a search facility, including a
'summary' with the results.

You could also look at Sphinx and there are more products that provide
such facilities.

Mark

robert.gilland wrote:
> Hi, We have a table with a list of 900,000 descriptions for different items.
>
> We want the user to be able to enter a string value and a result set come back with matching descriptions in the same way google does.
>
> Has anyone done this?
>
> or know how to do this?

--
Mark Rotteveel