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

3 votes213 views1 answer
Oracle list privileges
SQL
0 vote196 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
1 vote186 views1 answer
Oracle db create new schema
SQL
0 vote192 views2 answers
Sql server select where date
SQL
18 votes187 views6 answers
Creating table in MySQL
SQL
0 vote178 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
6 votes193 views1 answer
Oracle pl sql source
SQL
0 vote157 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
1 vote202 views1 answer
How to check the mysql version mac
SQL
11 votes204 views2 answers
How to import mysql database command line
SQL