JAEN

SQL

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

The same reference, with no signal at all

Every command on this site, held on your device. The app adds 632 more: 1,510 commands and 120 fix flows, searchable with no connection. Free to install, no ads (some content is a one-time purchase).

Get it free on the App Store