SQL 的WHERE条件怎么写

[summer353]

现在我表如下
ID NAME
1 abcd
2 bcde
3 cdef
4 defg
现在我通过一个传入的条件值 为 abcdef
怎么写WHERE条件才能把1,2,3 3条记录查出来,排除第四条记录

[蒋晟]

INSTR

[lisong770818]

with a as
 (select 1 ID, 'abcd' NAME
    from dual
  union all
  select 2 ID, 'bcde' NAME
    from dual
  union all
  select 3 ID, 'cdef' NAME
    from dual
  union all
  select 4 ID, 'defg' NAME from dual
  
  )
select a.* from a where instr('abcdef', name) > 0

[Alessandro_]

有点没明白，直接where条件根据ID查询就会有你的结果！

[Alessandro_]

[Quote=引用 2 楼 lisong770818 的回复:]

SQL code
with a as
(select 1 ID, 'abcd' NAME
from dual
union all
select 2 ID, 'bcde' NAME
from dual
union all
select 3 ID, 'cdef' NAME
from dual
union all
select 4 ID, 'defg……
[/Quote] 原来如此，学习了！