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 vote441 views5 answers
Right join
SQL
0 vote317 views1 answer
How to print mysql query of codeigniter query builder
SQL
5 votes355 views2 answers
Mysql dump mysql db cli
SQL
1 vote315 views1 answer
Simple project for database
SQL
0 vote308 views1 answer
Cast as decimal postgresql
SQL
-2 votes309 views1 answer
How to open database
SQL
-1 vote297 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
7 votes330 views2 answers
Create index mysql cli
SQL
0 vote321 views1 answer
Select into table variable
SQL
0 vote326 views1 answer
How to create a table based on another table in mysql
SQL