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 vote266 views1 answer
Mysql select top 2
SQL
3 votes303 views1 answer
Sql several or
SQL
0 vote319 views1 answer
How to find sql server name
SQL
5 votes328 views3 answers
Sql max value in column
SQL
0 vote327 views1 answer
Select from column mysql
SQL
0 vote345 views1 answer
Mysql remove last character
SQL
11 votes325 views5 answers
How to install sqlite3 python
SQL
0 vote311 views1 answer
Mysql get 2nd value in comma separated list
SQL
5 votes349 views2 answers
Sql constraint check value in list
SQL
0 vote343 views1 answer
Postgresql replace html tags from string
SQL