Akina

INSERT INTO messages(name, content, date) VALUES('${user.name}', '${user.content}',NOW())

TIME values may range from '-838:59:59' to '838:59:59'. The hours part may be so large because the TIME type can be used not only to represent a time of day (which must be less than 24 hours), but also elapsed time or a time interval between two events (which may be much greater than 24 hours, or even negative)

SELECT * FROM `dle_post` WHERE CONCAT('|', `xfields`, '|') LIKE '%|key|123|%'

SELECT count(*) from `runs` where `date` >= unix_timestamp(curdate());

SELECT count(distinct client) from `runs` where `date` >= unix_timestamp(curdate());

SELECT COUNT(*) FROM (
    SELECT 
        `client`, MIN(`date`) `first_run`
    FROM `runs` 
    GROUP BY `client` 
    HAVING `first_run` >= unix_timestamp(curdate())
) `todays_first_runs`;