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