DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world
Check How Mysql Index Is Used
EXPLAIN SELECT ... WHERE ...
Explain will tell you if your index work as you thought. (I forgot to login in the last two snippets)