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

4 votes314 views1 answer
Postgresql show current database
SQL
0 vote327 views1 answer
Sql select merge multiple values
SQL
0 vote317 views1 answer
Mysql_error replacement
SQL
0 vote343 views1 answer
Sql put two columns into one
SQL
1 vote338 views1 answer
Backup mysql data only
SQL
15 votes352 views4 answers
Mysql where value is null
SQL
18 votes307 views4 answers
Foreign key mySql
SQL
8 votes324 views1 answer
Oracle search source code
SQL
0 vote319 views1 answer
Ora 00001 error catch plsql
SQL
1 vote322 views2 answers
Sql multiline comment
SQL