mysql where子句使用'IN“或多个'OR'

Question

assuming query multiple conditions,

select AA.*,BB.* from AA left join BB on AA.key=BB.key 
where AA.key='red' or AA.key='green' or AA.key='blue' or AA.key='pink'

compare to

select AA.*,BB.* from AA left join BB on AA.key=BB.key 
where AA.key IN ['red','green',blue',pink']

In MYSQL, is any of the 2 options above faster than the other? I know using 'IN" is more pretty, but is it different in speed? (The tables have index on 'key')

I saw this post, but there is not reference about speed.

Answer 1

RJS IN clause is more faster then Multiple OR statement in SQL.

for example if you have 3 to 5 thousand record then IN query will be 5(approx) time faster as compared to the multiple OR statement.