SQL服务器: need to escape [?

Question

我需要在 SQL Server 的 sql 查询中转义 [

select * from sometable where name like '[something]';

我实际上正在寻找某个东西之前的 [，但我不希望它像通配符一样。我尝试过:

select * from sometable where name like ''[something]';

但是从中得到错误消息:

Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'something'. Msg 105, Level 15, State 1, Line 1 Unclosed quotation mark after the character string ';

Answer 1

用途:

select * from sometable where name like '[[]something[]]';

您也可以使用:

select * from sometable where name like '\[something\]' escape '\';

描述于 LIKE (Transact-SQL) on MSDN .