One of the recent questions I had to answer focused on analyzing text data. How have you solved this problem in the past? I was not sure how to create an optimized solution for both efficiency and completeness. My solution I came up with used a join condition that had the following query structure:
join keywords on
text_data.text like concat('%', keywords.keyword, '%')
This seemed like a brute force method, but it worked.