我需要“打开”为 2 并单击为 1 但现在我越来越喜欢打开为 5 并单击为 2
"SELECT COALESCE(sum(requested),0) as requested, COALESCE(sum(processed),0) as processed, COALESCE(sum(open),0) as open, COALESCE(sum(click),0) as click, COALESCE(sum(dropped),0) as dropped, COALESCE(sum(delivered),0) as delivered, COALESCE(sum(spamreport),0) as spamreport, COALESCE(sum(deferred),0) as deferred, COALESCE(sum(bounce),0) as bounce, COALESCE(sum(unsubscribe),0) as unsubscribe FROM CAMPAIGN_REPORTS WHERE _kftCampaingID='".$campaignId."'"
sum()按预期工作。如果您希望将 0 以上的任何值视为 1，请编写如下 if 条件。话虽如此，coalesce在这里看起来是多余的。