title: Encryption in SQL (SQLite)
body: <p>I want to encrypt particular data I wish in the tables..</p>
  
  <p>For example,</p>
  
  <p>I need something like this:</p>
  
  <pre><code>update mytable set column1 = encrypt(column1, "key") where condition;
  </code></pre>
  
  <p>and this:</p>
  
  <pre><code>select decrypt(column1, "key") from mytable where condition;
  </code></pre>
  
  <blockquote>
    <p>Is threre any simple in-built SQL function in <strong>SQLite</strong> to accomplish
    this?</p>
  </blockquote>
  
  <p>I have a Java function for encrypt() and decrypt(), I need to bulk encrypt the table column and it will be too slow if I read the column, apply the function and then write back. Please advise.</p>
  
  <p>Thanks in advance.</p>