= only finds exact text. To search for text that *starts with*, *ends with* or *contains* something, SQL uses LIKE with a pattern.
Loading data...
The % wildcard means "any sequence of characters, even empty". Let's find the names that start with P:
↗️
Loading editor...
↶
↷
Pyrochu and Plantachu match: the pattern says "a P, then anything".
Case sensitivity
In SQLite, LIKE ignores the case of ASCII letters: 'p%' also matches Pyrochu. Other databases differ (PostgreSQL's LIKE is case-sensitive and offers ILIKE). Always check your database's behaviour.