Select data based on field name

[Mike Demaris]

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