Like operator with IN clause

  logon_triggers_exclude values:

MYDB

YDB%

SELECT DISTINCT a.DATABASE_ID,  FROM cp_database a  WHERE NOT EXISTS ( SELECT 1                        FROM logon_triggers_exclude lt                      WHERE a.database_name LIKE lt.database_name);