回避特殊字符
' | '' | 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 ' %[[]% ' |