如何查询列相似字段

[churchatp1]

请问如果查询列相似字段:
例如
要查询表b里面b列like表a的a列的记录,应该怎么写sql语句
也就是
表b:
b
'a你好a'
'不好'
表a:
a
'你好'

结果:
要查出
'a你好a'



谢谢

[churchatp1]

没有人知道吗?顶一下,分不够可以再开贴给,

[xiaoxiao1984]

SQL> select b.* from
2 (
3 select 'a你好a' as text from dual
4 union
5 select '不好' from dual
6 union
7 select '不开心' from dual
8 )b
9 cross join
10 (select '你好' as text from dual
11 union
12 select '不' from dual
13 ) a
14 where instr(b.text, a.text) >0
15 /

TEXT
------
不好
不开心
a你好a

SQL>
SQL> select b.* from
2 (
3 select 'a你好a' as text from dual
4 union
5 select '不好' from dual
6 union
7 select '不开心' from dual
8 )b
9 cross join
10 (select '你好' as text from dual
11 ) a
12 where instr(b.text, a.text) >0
13 /

TEXT
------
a你好a