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 vote282 views1 answer
To Create directory
SQL
3 votes276 views2 answers
Sql end of month
SQL
0 vote281 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
1 vote261 views1 answer
Mysql history command
SQL
3 votes354 views1 answer
Sql select second max
SQL
0 vote265 views1 answer
Get server date mysql
SQL
2 votes269 views1 answer
Mysql find tables with name
SQL
3 votes285 views1 answer
Select count from table mysql
SQL
0 vote282 views4 answers
Stored procedure sql
SQL
0 vote270 views1 answer
Mysql query to add hours to column in table
SQL