LIKE / ワイルドカード
SafePattern matching
SELECT ... WHERE col LIKE '%値%';
Wildcard search with % and _. Prefix matches use indexes; a leading % forces a full scan — know the cost.
Examples
SELECT name FROM users WHERE name LIKE '山田%';Index-friendly prefix match
Syntax
WHERE col LIKE 'a%'(前方) | '%a'(後方) | '%a%'(部分)
Before you run it
Read only.
Related commands
- SELECTRead data
- SHOW INDEXInspect indexes
The same reference, with no signal at all
Every command and flow from this site, held on your device and searchable with no connection. Free to install, no ads.
Get it free on the App Store