indexing - How do I check if an index exists on a table field in MySQL? -

i've needed google couple times, i'm sharing q/a.

use show index so:

show index [tablename] 

docs: https://dev.mysql.com/doc/refman/5.0/en/show-index.html