As I understand, it's tricky to get FTS to do substring matching, no? What's
the best way to do that?
Thanks!
Paul
________________________________
From: Roger Binns <rog...@rogerbinns.com>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
Sent: Friday, January 25, 2013 12:01 PM
Subject: Re: [sqlite] Substring Search Across Many Columns
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 25/01/13 11:30, Paul Vercellotti wrote:
> I'm trying to match a substring (case-insensitive) across multiple
> columns and want it to go fast; it's very slow to do a query like '...
> WHERE name LIKE "%fish%" OR desc LIKE "%red%" OR title LIKE
> "%soup%"...'
>
> Will creating a composite index ...
If you are concerned about performance then SQLite already has a solution
for you:
http://www.sqlite.org/fts3.html
Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
iEYEARECAAYFAlEC5IEACgkQmOOfHg372QSNawCfcstLdcz+03qyerOuCRD1apxg
OsIAoKmLokdeHugQARtxRmD3bxVwBu99
=MyPO
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users