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 vote285 views1 answer
Sintaxis SELECT sql
SQL
0 vote284 views1 answer
How to select a row in sql
SQL
4 votes337 views4 answers
Check constraint in ms sql
SQL
3 votes309 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
3 votes322 views1 answer
What is having
SQL
1 vote292 views3 answers
What is union in sql
SQL
8 votes268 views1 answer
Oracle add month
SQL
0 vote277 views1 answer
Oracle exchange partition
SQL
0 vote280 views1 answer
Docker open terminal mysql server
SQL
1 vote313 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL