NOT EXISTS(query)

TIDAK ADA (permintaan)

Syntax

MYSQL Copy

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

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

Contoh

Example

Whether the result of a query contains no rows:

MYSQL Copy

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

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