LIKE
Searches text with a pattern.
Syntax
WHERE column LIKE pattern;
Description
% for any number of characters, _ for a single character. 'A%' for those starting with A.
Example
Loading editor…
Expected output
Alex Ava
When to use?
Text search (starts with/ends with/contains).