Hi

So if I have a table with a structure as below:

Code:
CREATE TABLE `employee` (
  `id` INT(10) NOT NULL AUTO_INCREMENT,
  `full_name` INT(64) NOT NULL,
  `email` VARCHAR(255) NOT NULL,
  `mobile` VARCHAR(64) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `mobile` (`mobile`)
) ENGINE=MYISAM DEFAULT CHARSET=latin1
and I run a query

Code:
SELECT * FROM employee WHERE email='abc@example.com'

Will the index work in this case? (notice the unique index assigned)


Thanks for any inputs.