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

6 votes108 views2 answers
WHERE value IS sql
SQL
1 vote128 views1 answer
Postgres delete from where date is greater than specific date
SQL
0 vote124 views1 answer
Make a socket server to detect changes in mysql
SQL
10 votes111 views4 answers
Primary key sql
SQL
0 vote115 views1 answer
How to check even or odd in sql
SQL
1 vote111 views1 answer
Sql server 2012 query history
SQL
-1 vote132 views5 answers
Left join sql
SQL
0 vote128 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
1 vote126 views1 answer
Round one decimal place mysql
SQL
1 vote129 views1 answer
Postgresql create table with timestamp
SQL