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 vote390 views2 answers
Mysql cast to varchar
SQL
2 votes342 views2 answers
Sql strip non alphanumeric characters
SQL
19 votes336 views2 answers
Mysql tinyint max value
SQL
0 vote357 views1 answer
Create a sql server database programmatically
SQL
3 votes388 views1 answer
Mysql group_concat distinct
SQL
3 votes329 views1 answer
Define REGEXP?
SQL
0 vote325 views1 answer
Sql create table with references not primary key
SQL
4 votes347 views6 answers
Second max salary in sql
SQL
0 vote357 views1 answer
Mysql 8 geo to json
SQL
5 votes298 views1 answer
Alter table default value mysql
SQL