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 vote296 views1 answer
How to change the field size of an existing column
SQL
0 vote299 views1 answer
Optimize sql query
SQL
0 vote315 views1 answer
Do you know sql
SQL
2 votes298 views1 answer
Merge two columns in sql oracle
SQL
2 votes303 views1 answer
Sql count having
SQL
0 vote298 views1 answer
Joins vs includes
SQL
5 votes327 views2 answers
Postgresql add not null constraint
SQL
17 votes304 views3 answers
Cast in sql server
SQL
2 votes339 views1 answer
Show max_allowed_packet mysql
SQL
1 vote295 views1 answer
Create temporal table in sql
SQL