php - 匹配以单词显示，而不是 mysql 中的数字

Question

我有一个 select 语句试图从数据库中选择匹配项，但在获得结果后，匹配项是单词，而不是数字。

SELECT DATA ,  
"CASE WHEN data LIKE  '%one two%' THEN 2 
ELSE CASE WHEN data LIKE '%one%' THEN 1
ELSE 0
END
END
END" AS  'matches'
FROM remember
LIMIT 0 , 30

结果:

列匹配:

"CASE WHEN data LIKE  '%love%' THEN 2" ELSE CASE W...
"CASE WHEN data LIKE  '%love%' THEN 2" ELSE CASE W...
"CASE WHEN data LIKE  '%love%' THEN 2" ELSE CASE W...

预期结果:

列匹配:

2
1
0

Answer 1

您不需要多次使用 CASE:

SELECT CASE WHEN data LIKE  '%one two%' THEN 2 
            WHEN data LIKE '%one%' THEN 1
            ELSE 0 
            END AS  'matches'