查询名字中含有某个字(中文)的sql语句怎么写？

[nnceo]

rt

[zarge]

select * from table1 where name like '%中文%'

[txlicenhe]

select * from yourTable where name like '%中文%'
or
select * from yourTable where charindex('中文',name) > 0

[pengdali]

select * from yourTable where charindex('中文',name) > 0

速度比like块

[haozhiyuan2003]

select * from yourTable where name like '%中文%'
or
select * from yourTable where charindex('中文',name) > 0

[---涛声依旧---]

select * from yourTable where 名字 like '%中文%'
or
select * from yourTable where charindex('中文',名字) > 0

[suntt]

select * from yourTable where charindex('中文',name) > 0