在 MySQL 查询中,如果我传递:
case guides.Gud_Publish_Date
when null then "Unscheduled"
else "Forth Coming Titles"
end
那么即使 Gud_Publish_Date 有值,它仍然认为所有内容都是 null。完整的 SQL 语句如下:
SELECT guides.Gud_Id
, guides.Gud_Image
, guides.Gud_SubEditor
, guides.Gud_Reprint_Status
, guides.Gud_Publish_Date
, guides.Gud_Img_Chk
, guides.Gud_Published
, guides.Gud_View
, (
CASE guides.Gud_Publish_Date
WHEN NULL
THEN "Unscheduled"
ELSE "Forth Coming Titles"
END
) AS Schedules
FROM guides