I am needing a way to either determin if a field in a table is indexed OR list indexed fields for a table with php. It would be something like you would see in phpmyadmin where it shows you the indexed fields, but I am needing to check fields before reindexing in a script.
Thanks!
Finding indexed fields in tables
Moderator: General Moderators
You might be interested in http://dev.mysql.com/doc/refman/5.0/en/show-index.html