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

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

Answer

Use SHOW INDEX like so:

SHOW INDEX FROM [tablename]

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

Leave a Reply

Your email address will not be published. Required fields are marked *