mysql中如何使用case_如何在MySQL中正确使用CASE..WHEN

这里是一个演示查询，注意它很简单，Fetches只在base_price为0的地方，

然而，它选择条件3：

SELECT

CASE course_enrollment_settings.base_price

WHEN course_enrollment_settings.base_price = 0 THEN 1

WHEN course_enrollment_settings.base_price<101 THEN 2

WHEN course_enrollment_settings.base_price>100 AND

course_enrollment_settings.base_price<201 THEN 3

ELSE 6

END AS 'calc_base_price',

course_enrollment_settings.base_price

FROM

course_enrollment_settings

WHERE course_enrollment_settings.base_price = 0

base_price是decimal(8,0)

当在我的DB上运行这个时，我得到：

3 0

3 0

3 0

3 0

3 0