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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users