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 vote345 views1 answer
Monthly Birthday SQL Query
SQL
4 votes341 views3 answers
Mysql modify foreign key
SQL
6 votes388 views2 answers
Foreign key sqlite3 python
SQL
0 vote334 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
0 vote334 views1 answer
Select value from previous row in postgresql
SQL
0 vote381 views1 answer
Oracle concat datetime
SQL
0 vote364 views1 answer
Sql server insert inner join
SQL
10 votes366 views2 answers
Sql pagination offset
SQL
0 vote353 views1 answer
Django how to get query result count
SQL
0 vote384 views1 answer
Google sheets data validation custom formula filter
SQL