[mysql] query datetime field only by time

[Costas]

we have these records :

using :

SELECT *
FROM  user_working_hours
WHERE EXTRACT(HOUR_SECOND from date_start) between 100000 and 100500

using :

SELECT *
FROM  user_working_hours
WHERE EXTRACT(HOUR_SECOND from date_start) between 100000 and 100600

using :

SELECT *
FROM  user_working_hours
WHERE (EXTRACT(HOUR_SECOND from date_start) between 100000 and 100600) AND (EXTRACT(HOUR_SECOND from date_end) between 153000 and 153100)

just for the history, using :

SELECT *
FROM  user_working_hours
WHERE HOUR(date_start)>15