Text Mining With SQL

[Community_Admin]

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:

select
  text_data.id
  , text_data.text
  , keywords.keyword
from
  text_data
  join keywords on
    text_data.text like concat('%', keywords.keyword, '%')

This seemed like a brute force method, but it worked.