php mysql 查询判断周几

$where .= " and (DAYOFWEEK( from_unixtime(`px_time`, '%Y-%m-%d')) = 1)";  //周日从1开始

原文地址:https://www.cnblogs.com/weiyiyong/p/7813133.html