``` LIKE 'abc%%' ESCAPE '%' -> REGEXP 'abc%' LIKE 'abc%%' -> REGEXP 'abc.*.*' LIKE 'abc%' -> REGEXP 'abc.*' ``` That is, the % wildcard is a regex .* the _ wildcard is . ESCAPE allows you to set the an alternate \ (escape) character -- the default is to have *no* escape character. So the sequence '%%' means `'.*.*'` unless the escape character is '%' in which case is is simply a match for the single character %