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
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
Freela
