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 vote102 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote108 views1 answer
Create mysql pool connection python flask
SQL
0 vote102 views1 answer
Postgres select except
SQL
0 vote108 views1 answer
Oracle get running queries
SQL
0 vote107 views1 answer
Install squirrel sql ubuntu
SQL
0 vote108 views1 answer
Oracle to_number
SQL
0 vote147 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
5 votes103 views1 answer
Sql add column after another
SQL
0 vote110 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote111 views1 answer
Convert polygon to text in mysql
SQL