mysql optimization with IN or OR

Question

Dear all,

I have a set of large values that need to be compared in mysql.

May I know which is faster? For example:

Opt 1:
SELECT * FROM table WHERE v = 1 or v = 2 or v = 3 or v = 4 or... v = 100

Opt 2: 
SELECT * FROM table WHERE v IN (1,2,3,4,5,6,7,8,...,100)

May I know which option is faster for large value? Is there any better solution? Thank you.

Answer 1

Are these all consecutive numbers? Then I would use

SELECT * FROM table WHERE v BETWEEN 1 AND 100

Answer 2

When I was studying databases my tutor told me that they effectively boil down to the same thing.

Answer 3

Assuming the numbers will not be consecutive, the IN clause is preferred for two reasons:

1. More readable
2. Optimized to run faster than OR statements.