Sql not contains

SELECT * FROM tbl WHERE tbl.col NOT LIKE '%text%';

Sql doesn't contain

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

Source: peachpit.com

Similar codes

0 vote190 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote195 views1 answer
PGSQL dynamic table name
SQL
4 votes183 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
0 vote237 views1 answer
Add week ending date sql server
SQL
8 votes226 views4 answers
Convert date to dd/mm/yyyy sql
SQL
1 vote234 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
0 vote202 views1 answer
Mysql local password denied
SQL
0 vote193 views3 answers
Query string not ending with with vowels
SQL
0 vote205 views1 answer
Frename oracle
SQL
3 votes181 views1 answer
Oracle list dates without weekends
SQL