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

2 votes270 views1 answer
Sql string_agg
SQL
1 vote263 views1 answer
Sqlserver create table from select
SQL
0 vote237 views1 answer
Mysql database is not starting in xampp
SQL
-1 vote247 views1 answer
What is in operator
SQL
1 vote262 views1 answer
Hexadec to sql REDSHIFT
SQL
1 vote263 views1 answer
Sqlalchemy order_by
SQL
1 vote236 views1 answer
Sql get all columns from one table but one from another inner join
SQL
22 votes254 views4 answers
Show list of users in mysql
SQL
11 votes232 views2 answers
Sql between date range
SQL
0 vote247 views1 answer
Get foreign table names mysql
SQL