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 vote166 views1 answer
Add constraint sql
SQL
0 vote174 views1 answer
Sql make sure every user is unqiuew
SQL
0 vote178 views1 answer
How to drop a trigger in postgresql
SQL
3 votes165 views2 answers
Having in mysql
SQL
3 votes162 views1 answer
Sql cast to integer
SQL
0 vote157 views1 answer
Sql python hwo to pass a list in paramerter
SQL
0 vote197 views1 answer
Add timestamp column to existing table t-sql
SQL
0 vote172 views1 answer
Insert overwrite table in mysql in nifi
SQL
0 vote162 views1 answer
Flask sqlalchemy update row
SQL
1 vote124 views1 answer
Flask-sqlalchemy filter_by contains
SQL