Hello all, I've looked through the archived mailing list and although I am sure my question is common, for some reason, I couldn't find an answer.
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*'; I would like to return the row above. However, I've tried this and it doesn't seem to work. It seems that prefix matching works though. So, if I do: select * from myTable where myTable match 'hello*'; that seems to return the right result. I am currently using FTS3 in version 3.6.2 and I have all the columns that I would like to index in the same virtual table. Thanks, Jon _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
