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 vote250 views1 answer
Spark sql grows beyond 64 kb
SQL
8 votes252 views1 answer
Oracle search stored procedures for text
SQL
0 vote231 views1 answer
How many rows affected in sqllite
SQL
0 vote251 views1 answer
Select place default lat long
SQL
2 votes267 views1 answer
Postgresql group by month and year
SQL
0 vote222 views1 answer
Mysql max number not returning correct value
SQL
1 vote235 views1 answer
Sometimes i cant edit sql developer
SQL
1 vote226 views1 answer
Full sql mode
SQL
5 votes244 views2 answers
Mysqldump password
SQL
1 vote230 views2 answers
T sql get foreign key
SQL