title: check if a row exists, if yes, update a column, else, insert a new row SQLITE JAVA ANDROID
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/3634984/insert-if-not-exists-else-update">INSERT IF NOT EXISTS ELSE UPDATE?</a>  </p>
  </blockquote>
  
  
  
  <p>I want to check if a row (with it's ID) exists in a database, 
  if yes, I want to update the column category, if it does not exist, i want to add a new row.
  Is this possible via a single query in sqlite (will be applied inside eclipse using java for an android app)</p>