SQLite Forum

How to select columns that have name beginning with same prefix?
Login
Using SQLITE, is there a way to select a set of columns that have name beginning with same prefix.

Suppose we have columns : PREFIX_col1, PREFIX_col2, ...

Is it possible to do a request like :

SELECT 'PREFIX_*' FROM mytable;
Which of course doesn't work.