Wouldn't
SELECT * FROM table1
EXCEPT
SELECT * FROM table2
solve this problem?
I think it does for the example provided. Not sure if it would work in
real-world environment.
-Ursprüngliche Nachricht-
Von: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
Im
You might want to check the following:
SELECT word FROM fts WHERE fts MATCH '^token'
Beginning with 3.7.9 this should only return records that have 'token' at the
beginning of the record.
See changelog of 3.7.9:
If a search token (on the right-hand side of the MATCH operator) in FTS4 begins
2 matches
Mail list logo