I have a multi-time array how to tell if there is a repetition.

problem description

clipboard.png

the environmental background of the problems and what methods you have tried

there is such a requirement, how to determine that these time periods overlap?

related codes

/ / Please paste the code text below (do not replace the code with pictures)

what result do you expect? What is the error message actually seen?

Feb.08,2022

is converted into a numeric range
00:00-08:00 = > 0-8 * 3600
. Interval comparison is fine

.
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3f642-2c4a2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b3f642-2c4a2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?