Comments - Getting Started with Indexes
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
I'm not clear what you're asking. An index is used for looking up rows.
SELECT * ...returns all the fields, not the index. If you clarify with your table structure and sample data, giving your desired results, it may be easier to help.