I have the following two questions to share: 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? I've been unable to come up with the expression on the right-hand side of LIKE to make this work.
Second, not having much *NIX knowledge, what's the difference between LIKE and GLOB apart from the masking characters and case-sensitivity? The documentation doesn't provide much information and Wikipedia shows that there are many 'standards' out there. How does GLOB work in SQLite? One or two examples of how LIKE and GLOB operate differently would be very helpful. Many thanks in advance, Staffan _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
