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

5 votes274 views2 answers
Get number of columns sql
SQL
0 vote281 views1 answer
Wordpress database query change url
SQL
0 vote261 views1 answer
Multiple left join mysql
SQL
0 vote257 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
1 vote298 views1 answer
Find size of all DB's postgres
SQL
6 votes328 views3 answers
What is where in sql
SQL
1 vote245 views1 answer
Sql update table remove spaces
SQL
0 vote264 views1 answer
SQL Query to delete all the tables in a database
SQL
0 vote263 views1 answer
Lesser than or equal to symbol in postgres
SQL
2 votes272 views2 answers
Sql percentage
SQL