如何找出所有名字中有'丰'字的记录？

[mobbs]

假设表cust中有一字段cust_name。如何得到所有名字中有'丰'字的记录(select语句)？
(假设名字的长度可以任意的)

[albertlinyi]

select * from cust where cust_name like '%丰%'

[yxxx]

select *
from cust
where cust_name like '%丰%'

[yown]

Select * from Cust
where cust_name like '%丰%'

[拼命三朗]

Select * from Cust
where cust_name like '%丰%'

[子陌红尘]

select * from cust where cust_name like '%丰%'

[newboy3205579]

select *
from cust
where cust_name like '%丰%'

[hu382334104]

怎么楼上都说完了嘛.

[jianeng310]

结了吧：）

[the_marine]

问一下，那种方法更快呢?

[railgunman]

用模糊查询来查找,不过模糊查询效率低了些,如果要查的表是大表的话,速度可能很慢.

[lixueailiyiyang]

select * from cust where instr(cust_name ,'丰',1)<>0

[mingxuan3000]

select * from cust where cust_name like '%丰%'

[北极海hein]

select * from cust where instr(cust_name ,'丰',1)<>0

==========
select *
from cust
where cust_name like '%丰%'