>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

Reply via email to