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