What’s mysql’s “BETWEEN” performance over..?

by

As I recall, there’s no difference. But see for yourself if: 

explain plan for 
SELECT * FROM `table` WHERE `unix_date` BETWEEN 1291736700 AND 1291737300

and:

explain plan for
SELECT * FROM `table` WHERE `unix_date` >= 1291736700 AND `unix_date` <= 1291737300

produce the same plans.

More Related Contents:

  1. Mysql: Select all data between two dates
  2. Select all months within given date span, including the ones with 0 values
  3. Delete the entire content of all table in a Database [closed]
  4. MyISAM versus InnoDB [closed]
  5. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  6. MySQL string replace
  7. What is the difference between utf8mb4 and utf8 charsets in MySQL?
  8. How do I find the MySQL my.cnf location
  9. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  10. MySQL select one column DISTINCT, with corresponding other columns
  11. How to use mysql JOIN without ON condition?
  12. How to remove all non-alpha numeric characters from a string in MySQL?
  13. Define a variable within select and use it within the same select
  14. ERROR: Error 1005: Can’t create table (errno: 121)
  15. Mysql Convert Column to row (Pivot table )
  16. Merge two tables in one SQL query and make the date values unique
  17. How to get all columns’ names for all the tables in MySQL?
  18. How do I get MySQL to use an INDEX for view query?
  19. Can I resolve this with pure mysql? (joining on ‘;’ separated values in a column)
  20. Greatest value of multiple columns with column name?
  21. insert data from one table to another in mysql
  22. MySQL load data infile – acceleration?
  23. I keep getting this mysql error code #1089
  24. How to close sqlalchemy connection in MySQL
  25. How do I lock on an InnoDB row that doesn’t exist yet?
  26. MySQL – why not index every field?
  27. INSERT INTO Table from multiple tables
  28. Mysql How do you create a clustered index?
  29. How to solve MySQL max_user_connections error
  30. Counting associated entries with Sequelize

Leave a Comment