Thread: How can I find fields that have a substring in common?
View Single Post
  #3 (permalink)  
Old 10-29-2006, 04:25 AM
Dimitar
 
Posts: n/a
Default ANY answer. Re: How can I find fields that have a substring in common?
My previous answer
[sql]
SELECT t0.s FROM t t0 , t t1 WHERE position(t0.s IN t1.s) <>0 GROUP BY t0.s HAVING count(*) > 1
[/sql]
obviously does not fullfill the requirements.
Reply With Quote