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

40 votes265 views4 answers
PostgreSQL add column
SQL
0 vote232 views1 answer
Mysqlimport
SQL
0 vote212 views1 answer
Mysql insert into select transaction c#
SQL
4 votes216 views1 answer
Mysql set max connections
SQL
0 vote178 views1 answer
Go install mysql
SQL
1 vote202 views1 answer
Mysql find most common value
SQL
11 votes191 views2 answers
Turn off safe mode mysql
SQL
2 votes273 views2 answers
Set value to null sql
SQL
0 vote187 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
0 vote135 views1 answer
How to see the content of tables in pgadmin
SQL