Hi sorry, just forget it. I have overseen a typo.
> Am 2019-11-01 um 15:00 schrieb mailing lists <[email protected]>: > > 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 _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
