主页 / dba / 问题 / 221240
Accepted
user3657339
Asked: 2018-10-30 02:23:32 +0800 CST

记录未使用 like 子句过滤

  • 772

使用以下查询来过滤记录：

select * from SearchRecord where searchkeyword1  like  '[%'

也试过这个

select * from SearchRecord where searchkeyword1  like  '%[%'

表中的记录包含这些值（如下所示，我需要最后 2 条记录，为什么这个简单的 like 不会过滤记录）

"Affiliate" means
"Agent's Rate of Exchange" means
["Aggregate Total Commitments" means
["Agreed Security Principles" means
sql-server

2 个回答

  1. Best Answer

    您的搜索模式包含一个wildcard character [，您应该将其括在方括号中或ESCAPE character像这样使用：

    declare @SearchRecord table (searchkeyword1 varchar(100));
insert into @SearchRecord values
('"Affiliate" means'),
('"Agent''''s Rate of Exchange" means'),
('["Aggregate Total Commitments" means'),
('["Agreed Security Principles" means');

select * 
from @SearchRecord 
where searchkeyword1  like  '![%' ESCAPE '!';

select * 
from @SearchRecord 
where searchkeyword1  like  '[[]%';

    所有这些都在这里描述： LIKE (Transact-SQL)

    • 12

  2. 可以ESCAPE '<some char>'用来告诉 SQL 如何解释 . 之后的字符。

    SELECT * FROM SearchRecord WHERE SearchKeyword LIKE '%\[%' ESCAPE '\';

    db<>在这里摆弄

    • 3

相关问题