String Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. String Functions
  4. 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 '\\\\'.
StringDescription
\%Matches one '%' character
\_Matches one '_' character

SELECT 'ABCDE!' LIKE 'ABCDE\_';
SELECT 'ABCDE_' LIKE 'ABCDE\_';