Check out example codes for "sql where part of string match". It will help you in understanding the concepts better.

Code Example 1

select * from docs where DOC_NAME like '%virus%spyware%'
-- OR
select * from docs where DOC_NAME like '%virus%' or DOC_NAME like '%spyware%'

Learn ReactJs, React Native from akashmittal.com