Staffan Tylen wrote: > First, assume two tables t1 and t2 where t1 has a text column a with data > and t2 has a text column p with patterns in LIKE format. For each a in t1 I > want to find all matching patterns p in t2. Is this possible using a single > SELECT clause?
SELECT * FROM t1 JOIN t2 ON t1.a LIKE t2.p > Second, not having much *NIX knowledge, what's the difference between LIKE > and GLOB apart from the masking characters and case-sensitivity? Character classes. A comment hidden in the source code explains: ** Globbing rules: ** ** '*' Matches any sequence of zero or more characters. ** ** '?' Matches exactly one character. ** ** [...] Matches one character from the enclosed list of ** characters. ** ** [^...] Matches one character not in the enclosed list. ** ** With the [...] and [^...] matching, a ']' character can be included ** in the list by making it the first character after '[' or '^'. A ** range of characters can be specified using '-'. Example: ** "[a-z]" matches any single lower-case letter. To match a '-', make ** it the last character in the list. ** ** This routine is usually quick, but can be N**2 in the worst case. ** ** Hints: to match '*' or '?', put them in "[]". Like this: ** ** abc[*]xyz Matches "abc*xyz" only Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
