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 vote299 views1 answer
Mysql check if lowercase
SQL
0 vote303 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
11 votes293 views1 answer
Sql insert multiple rows from select
SQL
0 vote293 views1 answer
Select count postgres double row count > 1
SQL
0 vote314 views1 answer
Compare subqueries oracle
SQL
0 vote275 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
0 vote306 views4 answers
Sql server date format yyyy-mm-dd
SQL
1 vote296 views2 answers
Drop function in sql
SQL
0 vote293 views1 answer
How convert into in in sql query
SQL
23 votes280 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL