现在假设你是老师teacherid is 1001。您被要求参加周一的课程,课程开始时间为11:00 AM并结束于1:00 PM。现在我的问题是,从表中查找您当时是否有空的 MYSQL/PHP 查询是什么batchroutine_regular?
提前致谢 :)
SELECT (COUNT(*) = 0) AS Available
FROM batchroutine_regular
WHERE
teacherid = 1001
AND class_day = 'Sunday'
AND (
(class_start <= MAKETIME(11,00,00) AND class_end >= MAKETIME(11,00,00))
OR (class_start <= MAKETIME(13,00,00) AND class_end >= MAKETIME(13,00,00))
)