WHERE ... IN (...)

[André Næss]

Hi

I'm not sure if this is the right group, but I can't think of any group more
competent to answer this question: How is the WHERE ... IN (...)
implemented? If I have for example: WHERE id IN(1,6,3,82,45), how does MySQL
do the checking? Does it sort the set and keep it in memory while checking,
or will it search through it every time? What is the optimal way to use the
IN()?

Regards
André Næss