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 vote197 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
0 vote183 views1 answer
Postpresql relation not found
SQL
0 vote180 views1 answer
How to print out column name differently in mysql
SQL
1 vote179 views2 answers
Datetrunc hour snowflake
SQL
1 vote212 views1 answer
Sql random sampling per group
SQL
7 votes204 views2 answers
Phpmyadmin change password
SQL
0 vote195 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
0 vote172 views1 answer
Sql server current time without date
SQL
0 vote171 views1 answer
Sql remove non numeric characters
SQL
1 vote178 views1 answer
Mysql show current queries
SQL