date - 忽略星期六和星期日

Question

我正在从我的客户数据库 (mysql) 中提取过去十天的所有记录
$offset1 =strtotime("-10 天"); $date3=date("Y-m-d",$offset1);

SELECT * FROM customers WHERE date between '$date3' and '$date' AND customer.custid = '$custid' ORDER by date DESC

我想省略周六或周日的日期，并希望将其放入我的查询而不是 php

如有帮助谢谢

Answer 1

您可以使用 MySQL 中的 DayOfWeek 函数。

SELECT * 
FROM customers 
WHERE date between '$date3' and '$date'
      AND DayOfWeek(date) <> 1
      AND DayOfWeek(date) <> 7
      AND customer.custid = '$custid' 
ORDER by date DESC