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 vote362 views1 answer
Redirection 301 htaccess nom de domaine
SQL
0 vote207 views1 answer
Radius search with point data in mysql
SQL
5 votes177 views1 answer
Oracle create table comment
SQL
0 vote160 views1 answer
How to insert multiple values in a single column in sql
SQL
0 vote157 views1 answer
See the structure of a table mysql
SQL
1 vote149 views1 answer
Mysql select another database
SQL
0 vote173 views1 answer
Savepoint mysql script
SQL
1 vote169 views1 answer
Sql select table header
SQL
5 votes156 views1 answer
Oracle sysdate
SQL
0 vote170 views1 answer
Take sql dump in to file
SQL