Dan provided the solution. Thanks!
-------
It's because by default the "[" character is treated as a
punctuation or separator character and ignored. As a result
the FTS query "[*" is equivalent to "" - which always returns
zero rows.
You can change the set of characters treated a punctuation
by changing using a different tokenizer:
http://www.sqlite.org/fts3.html#tokenizer
For example, to treat both "[" and "]" as part of tokens instead
of punctuation:
CREATE VIRTUAL TABLE xyz USING fts4(tokenize=unicode61
"tokenchars=[]");
-------
On 2014-02-12 11:05, Richard Hipp wrote:
On Wed, Feb 12, 2014 at 4:57 AM, Attila <dex...@xyzones.org> wrote:
I tried that one as well.
SQLite has no built-in MATCH function. If you want to use the MATCH
syntax, then you need to register your own MATCH function using
sqlite3_create_function().
--
Attila
@xyzones
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users