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 😜
Please sign in to leave a comment.