title: How to update column with ORMLite
body: <p>I have an already created database for Android application and I'm using ORMLite for query to SQLLite.</p>
  
  <p>I have added a column in category and I want to insert data in that column.
  I have row, e.g. </p>
  
  <pre><code>catId=5 catname="food" catType=?
  </code></pre>
  
  <p>I want to update <code>catType</code> on the basis of <code>catId</code>. How can I update this <code>catType</code> column with the <code>catId</code> in ORMLite.</p>
  
  <p>I am using this approach:</p>
  
  <pre><code>Dao&lt;Category, Integer&gt; catDao = getHelper().getCategoryDao();
  QueryBuilder&lt;Category, Integer&gt; queryBuilder = catDao.queryBuilder();
  queryBuilder.where().eq("categoryId", 5);
  PreparedQuery&lt;Category&gt; pq = queryBuilder.prepare();
  Category category = catDao.queryForFirst(pq);
  category.setCategoryType("BarType");
  catDao.createOrUpdate(category);
  </code></pre>
  
  <p>Please provide me a better solution.</p>