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 vote143 views1 answer
Create table in dbms cmds
SQL
0 vote167 views1 answer
Many rows to 1 string mysql
SQL
0 vote166 views1 answer
Replace sqlalchemy
SQL
0 vote163 views1 answer
How to get parent and child record in single query using sql
SQL
0 vote142 views1 answer
Version and edition of SQL Server Database Engine
SQL
0 vote142 views1 answer
Sql select most frequent value in column
SQL
0 vote145 views1 answer
Wordpress sql change site url
SQL
13 votes145 views3 answers
Uninstall mysql centos 7
SQL
2 votes135 views1 answer
SELECT INTO
SQL
8 votes141 views1 answer
Oracle all_source package body
SQL