How to select all entries of all days between 23:00 and 23:59

[Puckey Pee]

Hi All,
I think I have a simple question but cannot find the solution.
I need to select all the entries in a database with a timestamp where the time of day is between 23:00 and 23:59.

I tried for instance:

SELECT * FROM `states` WHERE `entity_id` = "sensor.energy_today" AND `last_updated` >= '23:00:00' and `last_updated` <= '23:59:00'

but that does not work.
Any suggestions?
Thx
PPee