query database with where contain.(x) code example

Example: sql not contains

SELECT * FROM tbl WHERE tbl.col NOT LIKE '%text%';