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 vote216 views1 answer
How to retrive the today date sql
SQL
0 vote179 views1 answer
Sql composite key
SQL
3 votes191 views1 answer
Oracle list invalid password ORA-01017
SQL
0 vote248 views3 answers
Classement rang mysql 7
SQL
19 votes190 views6 answers
What is mySQL
SQL
2 votes194 views1 answer
Mysql application.properties spring boot
SQL
0 vote175 views1 answer
Postgres select except
SQL
0 vote199 views2 answers
Faster mysql imports
SQL
0 vote214 views1 answer
TSQL function split string
SQL
1 vote206 views1 answer
Postgresql round double precision
SQL