Essentially, I am trying to run a query where I can search multiple keywords without invalidating the other filters in my WHERE statement.
My current query looks like this:
SELECT *
FROM Table
WHERE ResponseDateTime between '2020-01-01' and '2022-09-19 23:59:59.999'
and Location IN ('MN', 'NV', 'NY', 'TX', 'VA')
and Comments LIKE '%keyword%' OR Comments LIKE '%keyword2%' OR Comments LIKE '%keyword phrase%'
ORDER BY ResponseDate DESC
But when I do this, it returns comments that match any of the above keywords (that's fine) ignoring the date and location filters in place (that's not fine). What I need it to do is to return comments that match any of the above keywords within all comments for the date and location above.
I tried Googling and attempting Full-Text Search, but my database is not Full Text-indexable.