search for each word in a string in sql database code example
Example 1: search for partial string in sql
Where FirstName LIKE '%R%'
Example 2: 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%'