MySQL Forums
Forum List  »  MySQL Workbench

Select data based on field name
Posted by: Mike Demaris
Date: April 29, 2022 02:52PM


I would like to select certain columns, and the data therein, by the field name or field position in the table.

I would have several queries pulling data from varying numbers of columns, i.e. qry1 has 6 columns, qry2 has 3, etc.

I have used the information_schema to get the field names or ordinal_positions, but not sure how to get the data from those fields, then filter of course.

The source table in question is a data dump table, no relations.

Any help is appreciated.


Options: ReplyQuote

Written By
Select data based on field name
April 29, 2022 02:52PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.