Re: [sqlite] MATCH with punctuation in parenthesis causing error

, 2013 10:55 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] MATCH with punctuation in parenthesis causing error On Mon, Nov 4, 2013 at 1:38 AM, David de Regt <dav...@mylollc.com> wrote: I've worked around this issue a separate way, but I'd like to understand what went

Re: [sqlite] MATCH with punctuation in parenthesis causing error

- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Kevin Benson Sent: Sunday, November 3, 2013 10:55 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] MATCH with punctuation in parenthesis causing error On Mon, Nov 4, 2013 at 1:38 AM

Re: [sqlite] MATCH with punctuation in parenthesis causing error

On Mon, Nov 4, 2013 at 1:38 AM, David de Regt wrote: > I've worked around this issue a separate way, but I'd like to understand > what went wrong in the first place here. I have an FTS3 table, and if I > query with the following: > > SELECT * FROM table WHERE keywords MATCH

[sqlite] MATCH with punctuation in parenthesis causing error

I've worked around this issue a separate way, but I'd like to understand what went wrong in the first place here. I have an FTS3 table, and if I query with the following: SELECT * FROM table WHERE keywords MATCH '(blah!)' I get the following error: malformed MATCH expression:_[(blah!)] If I