CODE EXAMPLE FOR SQL

mysql force query to use index

/* if mysql is dumb and using wrong index you can force it to use
the one you want like so:*/
select name from users USE INDEX (index4) where name='hello';