The difference between mysql’s range query and multi-valued precision query in the query principle is What?

  mysql, question

I only know that the range query between and > < can use the index once, but not the second time, and multi-value accurate search in does not have this limit, why? How to explain the index principle?

I don’t know what you are talking about, both of which can be indexed. What do you mean by the second time