I want to return records based on a wildcard search from a table of keywords
Current Table
Message | |
---|---|
Some Message |
Keyword Table
Words | |
---|---|
SomeWord1 | |
SomeWord2 |
Currently I am writing a query on something like this
SELECT * FROM table WHERE message LIKE '%SomeWord1%' OR message LIKE '%SomeWord2%'
Is there a more elegant way to do this wild card search using sort of subquery