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

1 vote180 views1 answer
Delete from inner join sql
SQL
10 votes175 views1 answer
Oracle object dependencies
SQL
2 votes161 views1 answer
Oracle kill job by sid
SQL
0 vote176 views1 answer
Ms sql filter all sympbol
SQL
9 votes185 views2 answers
SELECT User,Host FROM mysql.user;
SQL
12 votes164 views2 answers
Delete all nodes neo4j
SQL
0 vote236 views1 answer
Suhaib
SQL
3 votes181 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
0 vote185 views1 answer
Mysql change innodb to myisam
SQL
0 vote146 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL