Assume the following statements
CREATE VIRTUAL TABLE NamesFTS USING FTS5 (LastName);
INSERT INTO NamesFTS (LastName) VALUES('L.');
INSERT INTO NamesFTS (LastName) VALUES('"L."');
SELECT rowid FROM NamesFTS;
> 1
> 2
SELECT rowid FROM NamesFTS WHERE NamesFTS MATCH '"L."';
> 1
> 2
How do I get only the record with rowid 2 using a MATCH filter statement? How
to escape '"'?
Regards,
Hartwig
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
