SQL特殊字符的处理

回避特殊字符

'	''	SELECT * FROM TBL WHERE COL = 'ABC''DEF';
%	\%	SELECT * FROM TBL WHERE COL LIKE 'ABC\%\_%' ESCAPE '\';
_	\_	※最后一个%是通配符。
全角％	\%	SELECT * FROM TBL WHERE COL LIKE 'ABC\%\_\％\＿%' ESCAPE '\';
全角＿	\＿	全角字符当做半角字符处理
\	\\	SELECT * FROM TBL WHERE COL LIKE 'ABC\%\_\％\\\＿%' ESCAPE '\';
NCHAR NVARCHAR2		SELECT * FROM TBL WHERE COL LIKEC '%\＿%' ESCAPE TO_NCHAR('\')

符号	含义
LIKE '5[%]'	5%
LIKE '5%'	5 后跟 0 个或更多字符的字符串
LIKE '[_]n'	_n
LIKE '_n'	an, in, on (and so on)
LIKE '[a-cdf]'	a, b, c, d, or f
LIKE '[-acdf]'	-, a, c, d, or f
LIKE '[ [ ]'	[
LIKE ']'	]
	select*from  dbo.PersonalMember  where  strloginname   like ' %[[]% '