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
