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
