SQL · String functions

like with escape

Escapes wildcard characters so they match literally.

sqlRunnable example sql course

Syntax

like '%\%' escape '\'

Example

Open in the lab

SELECT '50%' LIKE '50\%' ESCAPE '\' AS matches;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.