Does sqlite support any kind of IF(condition) statement in a select

SqlSqlite

Sql Problem Overview

Does sqlite support the sql function "if" in the select statement?

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 does support a condition in the select what is the syntax is should be using?

I have checked http://sqlite.org/lang_corefunc.html but I can't see it.

Sql Solutions

Solution 1 - Sql

See the case expression.

> A CASE expression serves a role similar to IF-THEN-ELSE in other programming languages.

For your example

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

Solution 2 - Sql

You can use case for that:

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

Solution 3 - Sql

Since version 3.32.0 you can use iif(X,Y,Z):

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

From the codumentation: > The iif(X,Y,Z) function is logically equivalent to and generates the same bytecode as the CASE expression "CASE WHEN X THEN Y ELSE Z END".

Categories
Recommended Sql Solutions
Recommended Sqlite Solutions

Previous Solution:

Optimizing Kohana-based Websites for Speed and Scalability

PhpOptimizationPerformanceScalabilityKohana

Next Solution:

.NET Events - What are object sender & EventArgs e?

.NetEventsEvent Handling

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionMatt PetersView Question on Stackoverflow
Solution 1 - SqlmmmmmmView Answer on Stackoverflow
Solution 2 - SqlPaul DixonView Answer on Stackoverflow
Solution 3 - SqlSteakOverflowView Answer on Stackoverflow