我有一个选择语句,试图从数据库中选择匹配,但在我得到结果后,匹配是单词,而不是数字。
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
您不需要多次使用大小写:
SELECT CASE WHEN data LIKE '%one two%' THEN 2
WHEN data LIKE '%one%' THEN 1
ELSE 0
END AS 'matches'