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

2 votes223 views2 answers
Oracle create table if not exists
SQL
3 votes212 views1 answer
Laravel database Using Named Bindings
SQL
0 vote202 views1 answer
Sql last 7 days
SQL
5 votes243 views3 answers
Sql limit offset
SQL
0 vote211 views2 answers
Laravel: customize or extend notifications - database model
SQL
0 vote209 views1 answer
Connecting mySQL to STS
SQL
0 vote212 views1 answer
Mysql last 6 months
SQL
0 vote185 views1 answer
Heavy table in mysql
SQL
0 vote219 views1 answer
Sqlite unique multiple columns
SQL
0 vote206 views1 answer
Initcap in mysql
SQL