Answers for "sql where not contains"

sql not contains

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

Posted by: Guest on May-14-2020

sql where contains

SELECT * FROM mytable
WHERE column1 LIKE '%word1%'
   OR column1 LIKE '%word2%'
   OR column1 LIKE '%word3%'

Posted by: Guest on January-22-2020

Code answers related to "sql where not contains"