MySQL: Compare BETWEEN time

by

i think what you are looking for is:

SELECT * FROM table WHERE start < CAST('05:00:00' AS time) AND end > CAST('05:00:00' AS time)

I’m not sure if you need to use the CASTs, though this should also work.

SELECT * FROM table WHERE start < '05:00:00' AND end > '05:00:00'

More Related Contents:

  1. How can I tell when a MySQL table was last updated?
  2. 1064 error in CREATE TABLE … TYPE=MYISAM
  3. MySQL DELETE FROM with subquery as condition
  4. Does adding ‘LIMIT 1’ to MySQL queries make them faster when you know there will only be 1 result?
  5. Is it possible to query a tree structure table in MySQL in a single query, to any depth?
  6. How to use LOAD_FILE to load a file into a MySQL blob?
  7. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  8. Determine Rank based on Multiple Columns in MySQL
  9. Relational database design multiple user types
  10. Checking multiple columns for one value
  11. What is better in MYSQL count(*) or count(1)?
  12. mySQL longitude and latitude query for other rows within x mile radius
  13. #1273 – Unknown collation: ‘utf8mb4_unicode_ci’ cPanel
  14. How do I repair an InnoDB table?
  15. Get results that fall within marker radiuses from database
  16. How to enable INNODB in mysql
  17. Bash script to insert values in MySQL
  18. MySQL GROUP BY DateTime +/- 3 seconds
  19. How do I lag columns in MySQL?
  20. Calculate distance given 2 points, latitude and longitude [duplicate]
  21. Dynamic conversion of string into column name. MySQL
  22. How to write a (MySQL) “LIMIT” in SQL Server?
  23. SQL: deleting tables with prefix
  24. How to use a user variables in MySQL LIKE clause?
  25. sql group by versus distinct
  26. How do I write an SP in phpMyAdmin (MySQL)?
  27. Syntax error on MERGE statement
  28. How to pass a variable to a IN clause?
  29. Optimistic locking in MySQL
  30. Insert and set value with max()+1 problems

Leave a Comment