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

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

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

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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

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

mailing lists
Hi sorry,

just forget it. I have overseen a typo.

> Am 2019-11-01 um 15:00 schrieb mailing lists <[hidden email]>:
>
> 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
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users