Like

like is used for pattern matching. It is char-oriented.

_ is used to match characters while % is used to match substrings.

For example,

SELECT * FROM Table WHERE name LIKE 'Ca%l';

This can match both Carl and Carol.

SELECT * FROM Table WHERE name LIKE 'Ca_l';

will only match Carl.