Reports

After some testing, I have a solution that works performantly across the volume of data I need, however Yitzhak Khabinsky, I want to thank you for the effort you put to into your answer, which was very clever in it's approach.

For any:

select distinct s.ID
from 
    Sentences s
    inner join Keywords k on s.Sentence like  concat('%', k.keyword, '%')

For all:

select
    s.ID
from
    Sentences s
    inner join Keywords k on s.Sentence like  concat('%', k.keyword, '%')
group by s.ID
having count(*) = (select count(*) from Keywords)

Reasons:

Blacklisted phrase (0.5): thank you
Blacklisted phrase (0.5): I need
RegEx Blacklisted phrase (1): I want
Long answer (-0.5):
Has code block (-0.5):
Self-answer (0.5):
Low reputation (0.5):

Posted by: user978426

79410187