Re: Partial string matching between columns, tables

2005-09-20 Thread Yvan Strahm
Thank you Jasper It works, with a little change but it works yvan Jasper Bryant-Greene wrote: Yvan Strahm wrote: I have a varchar column 's1' in table t1. And a varchar column 's2' in table t2. Do you know how one could do something like this: select * from t1,t2 whe

Partial string matching between columns, tables

2005-09-20 Thread Yvan Strahm
Hello, I have a varchar column 's1' in table t1. And a varchar column 's2' in table t2. Do you know how one could do something like this: select * from t1,t2 where t1.s1 like %t2.s2 Thanks for your help -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscri