title: SQLite IF Exists Clause
body: <p>How to write IF EXISTS as shown in below query in SQLite? I read somewhere that IF clause doesn't exist in SQLite. What would be a better alternative for this?</p>
  
  <pre><code>if exists (select username from tbl_stats_assigned where username = 'abc' )
      select 1 as uname
  else
      select 0 as uname
  </code></pre>