Hello! Please, help me if you have a time for this. I have an sqlite database table: CREATE TABLE lemma ( id INTEGER PRIMARY KEY, base TEXT, preflex_id INTEGER, type_ancode TEXT, prefix_id INTEGER ) In the "base" column I store a string which I need to compare with another string, the problem is that "base" is a substring. So, I want to select records from this table where "base" is a substring for some string. I understand, that it's a beginner question, but I know only how to solve inverse problem using "LIKE" :( Thank you for reading it! -- View this message in context: http://old.nabble.com/Column-as-a-substring-tp26253867p26253867.html Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
