EXISTS(query)

MySQL 8.4 🇮🇩 Bahasa Indonesia

Apakah hasil kueri berisi baris apa pun.

Syntax

MYSQL

CREATE TABLE t (col VARCHAR(3));
INSERT INTO t VALUES ('aaa', 'bbb', 'ccc', 'eee');

SELECT EXISTS (SELECT * FROM t WHERE col LIKE 'c%');
1

SELECT EXISTS (SELECT * FROM t WHERE col LIKE 'd%');
0

Contoh

Example

MYSQL

CREATE TABLE t (col VARCHAR(3));
INSERT INTO t VALUES ('aaa', 'bbb', 'ccc', 'eee');

SELECT EXISTS (SELECT * FROM t WHERE col LIKE 'c%');
1

SELECT EXISTS (SELECT * FROM t WHERE col LIKE 'd%');
0