sql select with column name like

Question

I have a table with column names a1,a2...,b1.b2....

How can I select all those with column names like a%?

question from:https://stackoverflow.com/questions/5274594/sql-select-with-column-name-like

Answer 1

You cannot with standard SQL. Column names are not treated like data in SQL.

If you use a SQL engine that has, say, meta-data tables storing column names, types, etc. you may select on that table instead.