Re: [sqlite] FTS5: how to find special character sequence containing '.' and '"'

2019-11-01 Thread mailing lists 
Hi sorry,

just forget it. I have overseen a typo.

> Am 2019-11-01 um 15:00 schrieb mailing lists :
> 
> 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

[sqlite] FTS5: how to find special character sequence containing '.' and '"'

2019-11-01 Thread mailing lists 
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