sql not contains
SELECT * FROM tbl WHERE tbl.col NOT LIKE '%text%';sql not contains
SELECT * FROM tbl WHERE tbl.col NOT LIKE '%text%';like sql
WHERE CustomerName LIKE 'a%'
--Finds any values that start with "a"
WHERE CustomerName LIKE '%a'
--Finds any values that end with "a"
WHERE CustomerName LIKE '%or%'
--Finds any values that have "or" in any position
WHERE CustomerName LIKE '_r%'
--Finds any values that have "r" in the second position
WHERE CustomerName LIKE 'a__%'
--Finds any values that start with "a" and are at least 3 characters in length
WHERE ContactName LIKE 'a%o'
--Finds any values that start with "a" and ends with "o"sql where contains
SELECT * FROM mytable
WHERE column1 LIKE '%word1%'
OR column1 LIKE '%word2%'
OR column1 LIKE '%word3%'t_sql contains
SELECT * FROM table WHERE Contains(Column, "test");sql where contains part of string
-- To find an exact string
SELECT * FROM [table] WHERE [field] LIKE '%stringtosearchfor%'.sql table contains
IF (SELECT COUNT(*) FROM foos WHERE bar = 'baz') > 0Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
