Skip to main content

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() .

More lessons in Operators