SQLite Forum

How to select columns that have name beginning with same prefix?
i understand your Solution Mr:Larry
but what about a query that require 10 or 20 Columns from 50 or 100 columns ?
do i need to write All Fields Names 10 or 20 times for every query ?