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 vote200 views1 answer
Postgresql parse json array
SQL
1 vote240 views3 answers
Read all columns of a table sql
SQL
0 vote392 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote252 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
1 vote213 views1 answer
Mysql count multiple columns in one query
SQL
9 votes229 views4 answers
Postgresql export database
SQL
7 votes223 views3 answers
Convert ansi sql
SQL
0 vote231 views1 answer
Sql convert unix time to date
SQL
4 votes213 views1 answer
Sql query to make a existing column auto increment
SQL
0 vote223 views1 answer
My sql data file extention
SQL