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

Question

I've needed to Google this a couple times, so I'm sharing my Q/A.

Answer 1

Use SHOW INDEX like so:

SHOW INDEX FROM [tablename]

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