SQLite syntax for If Else condition

Question

I am using SQLite database. My table has a text column called "Password". Earlier for retrieving the values I used to execute a simple select * from myTable query. But now the requirement is that if Password value is not NULL then I need to show it as "Yes" or otherwise "No". It's something like:

select * from myTable if Password != NULL then Password = 'Yes' else Password = 'No' 

I searched a lot regarding this but I didn't get any proper link or example. Any help or suggestion would be really appreciated.

Answer 1

SELECT *,        CASE WHEN Password IS NOT NULL        THEN 'Yes'        ELSE 'No'        END AS PasswordPresent FROM myTable 

Answer 2

SQLite uses the CASE WHEN THEN END syntax. You can read more about that here: http://www.sqlite.org/lang_expr.html

I have not checked the syntax but I'm guessing something like this:

select *  from myTable CASE WHEN Password != NULL THEN Password = 'Yes' ELSE Password = 'No' END; 

Though I'm not sure that would work at all. If you're trying to get a YES or NO based on the presence of a password in the table for every record, perhaps this is closer to what you want:

SELECT Field1,      Field2,     (CASE WHEN Password != NULL THEN          'Yes'       ELSE          'No'       END) as 'Password' FROM myTable; 

Again, I do not currently have access to SQLite to test this myself so it probably needs some work.