Explain the use of REGEXP and LIKE operators. What’s the difference between them?

Uses full regular expressions (much more powerful).

Supports character classes, anchors, quantifiers, alternation, etc.

Case-insensitive by default (unless using REGEXP BINARY).

LIKE is simple, using only % and _ wildcards.

REGEXP is complex and powerful, using full regular expression syntax.

LIKE matches the entire string implicitly, while REGEXP can match anywhere unless anchored (^ or $).

REGEXP supports quantifiers, alternation (|), groups, character classes, etc.

LIKE may be faster for simple patterns, while REGEXP is slower but more flexible.