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 vote147 views1 answer
Import sql inside hide sql
SQL
1 vote130 views1 answer
Oracle list constraints
SQL
0 vote133 views1 answer
How to print records of employees hired in particular month in oracle
SQL
14 votes134 views2 answers
Install mysqldump
SQL
0 vote146 views1 answer
Rails sql query converstion
SQL
0 vote134 views1 answer
Const pool = mysql.createpool()
SQL
0 vote128 views2 answers
How to tun mysql on ubunto
SQL
0 vote150 views1 answer
Including parameters in OPENQUERY
SQL
0 vote126 views1 answer
SQL column name Oracle
SQL
0 vote180 views1 answer
Mysql grant access to one database
SQL