The fts3/4 documentation says:
"If the FTS table is an FTS4 table (not FTS3), a token may also be
prefixed with a "^" character. In this case, in order to match the token
must appear as the very first token in any column of the matching row."
So change "FTS3" to "FTS4" and it will likely work.
Dan.
On 30/8/62 16:31, mailing lists wrote:
Hi,
I could not find an example showing a result in the documentation, therefore I
created one by myself:
CREATE VIRTUAL TABLE myData USING FTS3(content);
INSERT INTO myData 'alpha beta';
1)
SELECT * FROM myData WHERE myData MATCH 'beta';
Result:
content
alpha beta
This is what I expected.
2)
SELECT * FROM myData WHERE myData MATCH '^beta';
Result:
content
alpha beta
This is what I did not expect. According to the documentation I expected to get
no rows because the column begins with alpha and not with beta.
What's the issue here? I tested these examples using version 3.24.0.
Regards,
Hardy
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
