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

7 votes175 views5 answers
Oracle alter table
SQL
0 vote320 views1 answer
Hue hive UploadingTextFiletoHive
SQL
1 vote155 views1 answer
Scaffold mysql database
SQL
0 vote188 views2 answers
Collation in sql
SQL
3 votes165 views2 answers
Sql add year to date
SQL
1 vote171 views2 answers
Update with inner join sql server
SQL
0 vote257 views1 answer
SQL query to verify the size of the table
SQL
0 vote138 views1 answer
Finish transaction sql
SQL
0 vote157 views1 answer
Sql date between one week
SQL
0 vote179 views1 answer
Mysql return column names when table is empty
SQL