Mega Code Archive

 

Categories / MySQL Tutorial / String Functions

 

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\_';