title: How to prepare column names dynamically in a sql query in sqlite?
body: <p>A table in SQLite DB contains 52 columns and their name as follows
  <strong>size0,size1,size2,size3,....size49,category,priority</strong>.</p>
  
  <p>while preparing the query for getting the values in only sizes columns i'm writing the query as</p>
  
  <p><strong>select size0,size1,size2,size3,....size49 from myTableName</strong>.</p>
  
  <p>Can we prepare these column names <strong>dynamically in a loop</strong>( <strong>because all size columns are in logical order</strong> ) <strong>within the query it self</strong>?</p>
  
  <p>and that <strong>query should work in sqlite</strong>.</p>
  
  <p>Any comments or suggestions would be appreciated.</p>
  
  <p>Thank you in advance.</p>