Re: [sqlite] Full text search without full phrase matches

that are similar. Kind regards, Philip Bennefall - Original Message - From: Black, Michael (IS) To: phi...@blastbay.com Sent: Thursday, June 14, 2012 9:34 PM Subject: Re: [sqlite] Full text search without full phrase matches Apache license is about as liberal as you can get. Damned

Re: [sqlite] Full text search without full phrase matches

: Black, Michael (IS) To: phi...@blastbay.com ; General Discussion of SQLite Database Sent: Thursday, June 14, 2012 9:03 PM Subject: Re: [sqlite] Full text search without full phrase matches Sounds to me like you want Lucene instead of SQLite http://lucene.apache.org/core/ Michael

Re: [sqlite] Full text search without full phrase matches

...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Philip Bennefall [phi...@blastbay.com] Sent: Thursday, June 14, 2012 1:32 PM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Full text search without full phrase matches Hi Simon, The ordering is not really the issue I am

Re: [sqlite] Full text search without full phrase matches

On 14 Jun 2012, at 7:32pm, Philip Bennefall wrote: > The problem is that it only returns a match if every single word is present. > I would like it to return matches if, say, mor than 2 or 3 of the specified > keywords are found. As far as I can figure, you need to write

Re: [sqlite] Full text search without full phrase matches

, Philip Bennefall - Original Message - From: "Simon Slavin" <slav...@bigfraud.org> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Thursday, June 14, 2012 8:24 PM Subject: Re: [sqlite] Full text search without full phrase matc

Re: [sqlite] Full text search without full phrase matches

On 14 Jun 2012, at 7:13pm, Philip Bennefall wrote: > That is unfortunate, if it is true that there's no way to accomplish this > with SqLite. To do just plain matching I can use an unordered hash map, so I > wouldn't need a database for that. The trouble with a string

Re: [sqlite] Full text search without full phrase matches

; <sqlite-users@sqlite.org> Sent: Thursday, June 14, 2012 7:24 PM Subject: Re: [sqlite] Full text search without full phrase matches On 14 Jun 2012, at 6:12pm, Philip Bennefall <phi...@blastbay.com> wrote: The trouble I have is that in my query, all the keywords don't ne

Re: [sqlite] Full text search without full phrase matches

On 14 Jun 2012, at 6:12pm, Philip Bennefall wrote: > The trouble I have is that in my query, all the keywords don't necessarily > have to be present in order for a successful match to be made. SqLite's fts > only seems to match if all the keywords are present, which I

Re: [sqlite] Full text search without full phrase matches

. How well the ordering matched. Do you have any tips? Kind regards, Philip Bennefall - Original Message - From: <pc...@sympatico.ca> To: <sqlite-users@sqlite.org> Sent: Thursday, June 14, 2012 7:01 PM Subject: [sqlite] Full text search without full phrase matches I had

[sqlite] Full text search without full phrase matches

-- Date: Wed, 13 Jun 2012 23:09:35 +0200 From: Philip Bennefall <phi...@blastbay.com> To: <sqlite-users@sqlite.org> Subject: [sqlite] Full text search without full phrase matches Message-ID: <A12309DB130E42BBA0590D664F66922A@chicken> Content-Type: text/plain; charse

[sqlite] Full text search without full phrase matches

-- Date: Wed, 13 Jun 2012 23:09:35 +0200 From: Philip Bennefall <phi...@blastbay.com> To: <sqlite-users@sqlite.org> Subject: [sqlite] Full text search without full phrase matches Message-ID: <A12309DB130E42BBA0590D664F66922A@chicken> Content-Type: text/plain; charse

[sqlite] Full text search without full phrase matches

Hi all, I am new to this maling list and to SqLite, so I wanted to start by thanking all of those who make this project a reality. It is a great tool. Now, to my question. I am trying to use the full text search feature to find rough matches for a chat robot. Basically I want to match as many