SQL数据库查询使用正则表达式如何查询中文？
最新回答
退场
2024-10-02 18:46:53
正则表达式
，它只模糊查询但是可以达到正则表达式的效果select * from shop_yw where name2 between '李明
' and '张明
'select * from shop_yw where name2 like '%李%'select * from shop_yw where name2 like '[李明-张立
]'select * from shop_yw where name2 like '[a-z]'select * from shop_yw where name2 like '-['李','赵']'select * from shop_yw where name2 like '[^a-f]'
夙愿未了
2024-10-02 05:39:04
距离感
2024-10-02 18:55:03
--中文对应的unicode码大致为（应该是精确的）：19968-40869
declare @tb table
(
[a] varchar(50)
)
insert @tb
select '客' union all
select '客' union all
select '中' union all
select 'a' union all
select '/' union all
select '.' union all
select '*' union all
select '@' union all
select '了' union all
select '鹰' select [a] from @tb where unicode([a]) between 19968 and 40869
go --结果
热门标签
