SQL：如何快速确定字符串（句子）是否包含我的SQL数据库中的单词？

Question

I have a question/problem. How can I determine quickly whether a string (sentence) includes words from my sql database? In PHP I use following code:

if(strpos($string,"abc")!==false) { 
    //abc is in $string 
} else {
    //abc isn't in $string 
}

Example:

Sql-Database: words -> my garden, sun, water

String: My garden is green.

Has someone suggestions? Thank you.

Answer 1

You can use a query like this:

SELECT
  *
FROM
  some_table
WHERE
  'My garden is green' LIKE BINARY CONCAT('%', some_column, '%')