sql query for get index of a columns in table mysql code example

Example: mysql show indexes on table

SHOW INDEXES FROM table_name;