| 23. 21. 2. To test for literal instances of a wildcard character, precede it by the escape character. |
|
|
If you do not specify the ESCAPE character, '\' is assumed. |
To search for '\n', specify it as '\\n'. |
To search for '\', specify it as '\\\\'. |
| String | Description | | \% | Matches one '%' character | | \_ | Matches one '_' character |
|
|
SELECT 'ABCDE!' LIKE 'ABCDE\_';
SELECT 'ABCDE_' LIKE 'ABCDE\_';
|
|