带有 % 的 PHP-SQL LIKE 子句

Question

数据库:

+----------------------+
+-KEYWORD-|-ANSWER-----+
+----------------------+
+hi,hello | Hey        +
+Who,where| example123 +
+----------------------+

文本框中的用户输入:

Who are you

SQL 查询

SELECT answer FROM chat WHERE keyword LIKE '%Who are You%' LIMIT 0,1

我得到的输出是空白

预期输出:

example123

Answer 1

也许你必须分解字符串来构建这样的请求:

SELECT answer FROM chat WHERE keyword LIKE '%Who%' OR keyword LIKE '%are%' OR keyword LIKE '%you%' LIMIT 0,1