MySQL Forums
Forum List  »  MySQL Workbench

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

Hello,

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.

Thanks

Options: ReplyQuote


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


Sorry, only registered users may post in this forum.

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.