Character | Description | Implementation |
---|---|---|
% | Matches any string of zero or more characters匹配任何0个或以上字符 | Oracle, IBM DB2 UDB, MS SQL Server 2000 |
_ (underscore) | Matches any single character within a string匹配任何一个字符 | Oracle, IBM DB2 UDB, MS SQL Server 2000 |
[ ] | Matches any single character within the specified range or set of characters匹配任何单个指定的的字符范围内的字符 | Microsoft SQL 2000 only |
[ ^ ] | Matches any single character NOT within specified range or set of characters匹配任何单个指定不再指定范围内的字符 | Microsoft SQL 2000 only |
在ORACLE中,可以用ESCAPE指定转义符,如果希望查询列中包含%的行,就可以使用 col like '%/%%' escape ' /',其中/后的% 就表示%本身,不再是匹配符