title: Update Command with Case in SQLite
body: <p>I want to update table <code>A</code> in such a way that if the attribute of the table column is desired then only it will change otherwise it wont change..</p>
  
  <pre><code>Update table A set B="abcd" ,C= (case when C="abc" then C="abcd" else C end) where column =1;
  </code></pre>
  
  <p>means <code>C</code> should be only change when in <code>column=1 and C value is abc</code>  otherwise <code>C</code> should not be update ..it should be dropped and only <code>B</code> changes. but if the <code>C
  </code> value get matched i.e abc give me the output 0 .. not changing to the abcd</p>