SELECT * FROM tbl WHERE tbl.col NOT LIKE '%text%';
/*Return data with the exception of the identified values*/ SELECT COLUMN1, COLUMN2 ... FROM SCHEMA_NAME.TABLE_NAME WHERE NOT (COLUMN1 LIKE '%VALUE%');