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.


Use SHOW INDEX like so:

SHOW INDEX FROM [tablename]


Leave a Reply

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