does sqlite supports any kind of IF(condition) statement in the select

Question

does anyone know if sqlite supports the sql function "if" in the select..

for example

select if( length( a ) > 4 , a , ' ') as b
from foo

which would return a if the length was over 4 chars long.. or else it would return ' ' as b

if it doe support a condition in the select what is the syntax is should be using?

i have checked http://sqlite.org/lang%5Fcorefunc.html but i cant see it.

Answer 1

I don't believe it does. You can create your own user written functions if you really require it to be done that way. Otherwise I'd just look at doing it within your application

Answer 2

See the case expression For your example

select case when length(a) > 4 then a else '' end as b
from foo

Answer 3

You can use case for that:

select case when length(a)>4 then a else ' ' end from foo;