sql语句查询一个字段不含'/'字符，怎么写效率最好？

[yuji821]

要查询test表中,name字段不含'/'

我这样写
select * from test where name not like '%/%'

[水族杰纶]

declare @t table([Name] varchar(10))
insert @t select 'adad/adad'
insert @t select 'ad'
insert @t select '456'
insert @t select '/'
select * from @t where [Name] not like '%/%'
select * from @t where charindex('/',[name])<=0
select * from @t where patindex('%/%',[Name])<=0
效率都差不多

[KOOK_OKKO]

学习

[tianhuo_soft]

charindex('/',name)<=0 --建议用这个


select * from @t where [Name] not like '%/%' --肯定是最差的
select * from @t where charindex('/',[name]) <=0 
select * from @t where patindex('%/%',[Name]) <=0  --这个还可以 但是用%就不好了_还可以接受

[M1CR0S0FT]

这个需求，怎么写效率都差不多。

[昵称被占用了]

where charindex('/',name)<=0

[regithanhu]

同意楼上的！

[忆轩辕]

[Quote=引用 2 楼 Haiwer 的回复:]
SQL codewhere charindex('/',name)<=0
[/Quote]

[hanjoe109]

charindex('/',name)<=0 這個好