Re: [sqlite] is there a way to escape a '-' in FTS match syntax?

[pehu]

I am new on NABBLE, so my reply comes perhaps too late...

FTS ignores all the characters not enclosed in [A-Za-z0-1], so it treats "T"
and "BONE" as two adjacent words.

You can search "T-Bone" using NEAR operator (NEAR/0 is used to find adjacent
words):

select * from FT where FT match 't NEAR/0 bone'

Regards

Gerard


Jason Boehle wrote:
> 
> Is there a way to escape the negatory syntax (the minus sign / dash) in
> FTS
> MATCH syntax?  I found that if I enclose the search term in quotes (ie.
> "T-Bone"), FTS does not treat the minus sign as a exclusion from the
> search.  I was just wondering if there is another way that does not
> require
> me to parse the search string into terms and quote the ones that have
> dashes
> in them.
> 
> Jason Boehle
> [EMAIL PROTECTED]
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
> 

-- 
View this message in context: 
http://www.nabble.com/is-there-a-way-to-escape-a-%27-%27-in-FTS-match-syntax--tp18298329p20879479.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] is there a way to escape a '-' in FTS match syntax?

[Jason Boehle]

Is there a way to escape the negatory syntax (the minus sign / dash) in FTS
MATCH syntax?  I found that if I enclose the search term in quotes (ie.
"T-Bone"), FTS does not treat the minus sign as a exclusion from the
search.  I was just wondering if there is another way that does not require
me to parse the search string into terms and quote the ones that have dashes
in them.

Jason Boehle
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users