SELECT
*
FROM
`eat_milk_every_day`
WHERE
ad = 10
这个是要操作的数据
SELECT
*
FROM
`eat_milk_every_day`
WHERE
ad = 10
AND
CASE
WHEN dha = 0 THEN
fe = 0 ELSE ca = 10
END
这个查询的意思是:当dha = 0的时候fe = 0 否则 ca = 10,用sql翻译就是: where ad = 10 and fe = 0。或者是:where ad = 10 and ca =10。到底是拼接哪个条件呢,要看case when后的判断数据的 dha字段。