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

1 vote184 views1 answer
Launch sql script from docker in mysql
SQL
1 vote200 views1 answer
Get table which have specific columns in mysql
SQL
1 vote218 views1 answer
Sql convert month name to number
SQL
0 vote199 views1 answer
Oracle call a function in a insert statement
SQL
0 vote227 views1 answer
MySQL import data from large CSV file
SQL
16 votes219 views2 answers
Oracle ddl
SQL
0 vote266 views1 answer
A network or instance-specific error sql server
SQL
-1 vote216 views1 answer
Module operator in oracle sql
SQL
3 votes206 views1 answer
Get all elements sql
SQL
0 vote209 views1 answer
Get who is hired in january in sql
SQL