LIKE

LIKEを使って、パターンマッチングが出来る。

https://www.postgresql.jp/document/7.2/user/functions-matching.html

postgresdb1=# SELECT * FROM profile;
  name  | address | age
--------+---------+-----
 Taro   | Tokyo   |  30
 Jiro   | Osaka   |  28
 Saburo | Nagoya  |  26
 Shiro  | Sapporo |  26
 Goro   | Fukuoka |  26
(5 行)

postgresdb1=# INSERT INTO profile VALUES ('Sato', 'Tokyo', 33);
INSERT 0 1
postgresdb1=# INSERT INTO profile VALUES ('Ito', 'Osaka', 31);
INSERT 0 1
postgresdb1=# INSERT INTO profile VALUES ('Sasaki', 'Kyoto', 29);
INSERT 0 1
postgresdb1=# SELECT * FROM profile WHERE name LIKE 'Sa%';
  name  | address | age
--------+---------+-----
 Saburo | Nagoya  |  26
 Sato   | Tokyo   |  33
 Sasaki | Kyoto   |  29
(3 行)

postgresdb1=# SELECT * FROM profile WHERE name LIKE '%to%';
 name | address | age
------+---------+-----
 Sato | Tokyo   |  33
 Ito  | Osaka   |  31
(2 行)

postgresdb1=# SELECT * FROM profile WHERE name LIKE '%ro';
  name  | address | age
--------+---------+-----
 Taro   | Tokyo   |  30
 Jiro   | Osaka   |  28
 Saburo | Nagoya  |  26
 Shiro  | Sapporo |  26
 Goro   | Fukuoka |  26
(5 行)

postgresdb1=#

'%'のところに、任意の文字列が入るようなパターンマッチング。