> I would like to look up partial strings across several columns using FTS3 > and MATCH. For example, if I have a column that has data, > 'helloThisIsATest'... and I do: > > select * from myTable where myTable match '*This*';
You can only use wildcards as a suffix - this is due to the nature of the indexes fts3 uses. I don't know of a possible workaround for this while still using fts3. I'd say that for this kind of request, you are condemned to use '... like "%This%". Alex. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users