select sql where string not contains code example

Example 1: sql not contains

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

Example 2: sql where contains part of string

-- To find an exact string
SELECT * FROM [table] WHERE [field] LIKE '%stringtosearchfor%'.