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

16 votes115 views2 answers
Add column if not exists mysql
SQL
0 vote113 views1 answer
Use mysql in java program
SQL
0 vote123 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
1 vote122 views1 answer
Alter constraint in sql
SQL
9 votes105 views3 answers
Show table columns mysql command line
SQL
0 vote101 views1 answer
How to search query in python3 sqlite3
SQL
0 vote120 views2 answers
Jsonb
SQL
1 vote96 views1 answer
Can not connect to mysql server
SQL
0 vote120 views1 answer
Oracle pl/sql check if file exists
SQL
2 votes150 views1 answer
Orcale index size
SQL