Marco Bambini wrote:
> I have a virtual FTS4 table and I would like to search for some terms inside
> a word, is that possible?
No.
> For example if a column contains "mysuperword mytestword" I would like to
> find it using the subword: "super".
>
> While with the MATCH operator it does not find anything:
> SELECT * FROM myTable WHERE myColumn MATCH '*super*';
The nearest you could do would be a phrase search.
This would require that every single letter is made a word:
INSERT INTO myTable(myColumn) VALUES('m y s u p e r w o r d m y t e s t w o r
d');
SELECT * FROM myTable WHERE myColumn MATCH '"s u p e r"';
(This is not what the FTS index was designed and optimized for.)
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
