Do I need an index on multiple WHERE IN() conditions?

Question

MySQL

The query will always take into account all fields, but it will look something like this:

SELECT * FROM someTable
WHERE 
someId1 IN (0, findId1) 
AND 
someId2 IN (0, findId2) 
AND ...

The question is, will a complex index on (someId1, someId2, ...) be used, or does B-tree allow only equals to search by index?
And will it be effective if the table size is up to 5k rows?

Answer 1

Will. EXPLAIN can answer such questions.