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.