Dear all, I would like to find all the rows in two text columns that share a common pattern. I can do this with Perl or Ruby using variables and regular expressions, but I am curious to know if there is a way to do it just using SQL.
For example, I wish to find entries that match 'foo', but without knowing what 'foo' is in these two columns: <column1> <column2> text has foo in it this text does not contain the pattern this one doesn't other text with the word foo in it Thank you in advance for your input. -Hien LE _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users