LIKE & Pattern Matching
Learn LIKE & Pattern Matching (Operators, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction LIKE matches text against a pattern with two wildcards: % (any number of characters, including none) and _ (exactly one character). NOT LIKE negates it, and ESCAPE lets you match a literal % or _. For full regular expressions use REGEXP or REGEXP_LIKE() .