Can MySQL FIND_IN_SET or equivalent be made to use indices?

If I compare explain select * from Foo where find_in_set(id,'2,3'); +----+-------------+-------+------+---------------+------+---------+------+------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+-------+------+---------------+------+---------+------+------+-------------+ | 1 | SIMPLE | User | ALL | NULL | NULL | NULL | NULL | 4 | Using where | +----+-------------+-------+------+---------------+------+---------+------+------+-------------+ with this one explain select * from Foo where id in (2,3); +----+-------------+-------+-------+---------------+---------+---------+------+------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+-------+-------+---------------+---------+---------+------+------+-------------+ | 1 | SIMPLE | User | range | PRIMARY | PRIMARY | 8 | NULL | 2 | Using where | +----+-------------+-------+-------+---------------+---------+---------+------+------+-------------+ It is apparent that FIND_IN_SET does not exploit the primary key. I want to put a query such as the above into a stored procedure, with the comma-separated string as an argument. Is there any way to make the query behave like the second version, in which the index is used, but without knowing the content of the id set at the time the query is written?