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 vote261 views2 answers
List all constraints in postgres
SQL
1 vote240 views2 answers
Changes not showing on website server odoo
SQL
0 vote253 views1 answer
Postgresql find biggest table
SQL
1 vote252 views1 answer
Expression number 1 of select list is not in group by clause
SQL
0 vote238 views1 answer
Create sql table from script inline primary key constraint
SQL
16 votes240 views2 answers
Add column if not exists mysql
SQL
16 votes237 views1 answer
Mssql int max value
SQL
0 vote239 views1 answer
R2dbc-postgresqldriver dependency
SQL
0 vote231 views1 answer
Sql remove non numeric characters
SQL
-1 vote221 views1 answer
How to use update trigger in sql
SQL