Re: Partial string matching between columns, tables

[Jasper Bryant-Greene]

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)
-- 
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/