I have a virtual FTS4 table and I would like to search for some terms inside a word, is that possible? For example if a column contains "mysuperword mytestword" I would like to find it using the subword: "super".
So with LIKE it worked but it is really slow: SELECT * FROM myTable WHERE myColumn LIKE '%super%'; While with the MATCH operator it does not find anything: SELECT * FROM myTable WHERE myColumn MATCH '*super*'; Any help? -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users