mysql - 如何在MySQL中添加多个WHERE语句？

任何人都可以给我一些示例进行包含多个WHERE语句的查询吗？

我有以下查询，我想添加WHERE privacy ='public'

$query = $this->db->query("SELECT DATE_FORMAT(eventDate,'%d') AS
day,eventContent,eventTitle,id FROM eventcal WHERE eventDate BETWEEN
'$current_year/$current_month/01' AND '$current_year/$current_month
/$total_days_of_current_month'");

提前致谢。

最佳答案

[..] WHERE privacy = 'public' AND (eventDate BETWEEN [..] )吗？