title: SQLite syntax for If Else condition
body: <p>I am using SQLite database. My table has a text column called &quot;Password&quot;. Earlier for retrieving the values I used to execute a simple <code>select * from myTable</code> query. But now the requirement is that if Password value is not <code>NULL</code> then I need to show it as &quot;Yes&quot; or otherwise &quot;No&quot;. It's something like:</p>
  <pre><code>select * from myTable
  if Password != NULL then Password = 'Yes'
  else Password = 'No'
  </code></pre>
  <p>I searched a lot regarding this but I didn't get any proper link or example.
  Any help or suggestion would be really appreciated.</p>