Top "Between" questions

SQL BETWEEN for text vs numeric values

BETWEEN is used in a WHERE clause to select a range of data between two values. If I am correct …

mysql sql numbers varchar between

What's mysql's "BETWEEN" performance over..?

Is there any better performance when querying in (particularly) mysql of the following: SELECT * FROM `table` WHERE `unix_date` BETWEEN 1291736700 …

mysql between

Three.js - How can I calculate the distance between two 3D positions?

I've already tried searching several different things on Google. Doesn't seem like I'm able to find anything. Thought I might …

camera three.js distance mesh between

Why use the BETWEEN operator when we can do without it?

As seen below the two queries, we find that they both work well. Then I am confused why should we …

sql between

mysql datetime field with index get a range 'like' vs. 'between and' performance

I just find mysql can query datetime using like: like '2013-06-12%' I think it can not use …

mysql datetime sql-like between

Is there a performance difference between BETWEEN and IN with MySQL or in SQL in general?

I have a set of consecutive rows I want to get based upon their primary key, which is an auto-incrementing …

sql mysql between

css difference between background: and background-image:

quick simple question In the following example of an external CSS page; body { background-image: url(background.jpg); } header { background: url(…

css background background-image between difference

regex for number between numbers

I'm in need of a regex, which takes a minimum and a maximum number to determine valid input, And I …

regex between

T-SQL Between Dates Confusion

I am working with T-SQL in SQL Server 2000 and I have a table TRANSACTIONS which has a date column TRANDATE …

tsql sql-server-2000 between

How Do I Search Between a Date Range, Using the ActiveRecord Model?

I am new to both Ruby and ActiveRecord. I currently have a need to modify and existing piece of code …

sql ruby-on-rails ruby activerecord between