>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!
Try ... LIKE ! select * from lemma where 'Whoever you love' like '%' || base || '%'; If a row contains base = 'Eve' it should turn up (just an example). _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users