Re: Partial string matching between columns, tables

[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 where t1.s1 like %t2.s2

SELECT * FROM t1, t2 WHERE t1.s1 LIKE CONCAT('%', t2.s2)

(untested)

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]