sql server:需要转义[? [英] sql server: need to escape [?
本文介绍了sql server:需要转义[?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我需要转义[在SQL Server的sql查询中
I need to escape [ in an sql query for SQL Server
select * from sometable where name like '[something]';
我实际上正在寻找一个[在某事之前,我不希望它像通配符。我试过:
I actually am looking for a [ before something and I don't want it to act like a wildcard. I tried :
select * from sometable where name like ''[something]';
但是从中获取错误消息:
But get error message from this:
消息102,级别15,状态1,行1附近的某事错误的语法。
消息105,级别15,状态1,行1
字符串后的未关闭的引号';
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 ';
推荐答案
使用:
select * from sometable where name like '[[]something[]]';
您也可以使用:
select * from sometable where name like '\[something\]' escape '\';
这篇关于sql server:需要转义[?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文