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 vote120 views1 answer
Oracle finding duplicate records
SQL
2 votes135 views1 answer
Sql column values comma separated
SQL
1 vote153 views2 answers
Mysql switch case
SQL
23 votes121 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote148 views1 answer
Create a sql server database programmatically
SQL
25 votes157 views1 answer
How to update an attribute in MySQL
SQL
0 vote169 views1 answer
Sql query to find percentage of null values in a table
SQL
4 votes168 views4 answers
Remove duplicate old value in mysql
SQL
12 votes221 views2 answers
Find duplicates mysql column
SQL
0 vote131 views1 answer
Mysql grant all on all databases
SQL