Answers for "sql search for part of string"

SQL
14

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
0

sql where part of string match

select * from docs where DOC_NAME like '%virus%spyware%'
-- OR
select * from docs where DOC_NAME like '%virus%' or DOC_NAME like '%spyware%'
Posted by: Guest on April-19-2020

Code answers related to "sql search for part of string"

Code answers related to "SQL"

Browse Popular Code Answers by Language