contains sql not working code example

Example: sql not contains

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