Sql conditionals
From wikinotes
You can substitute values in your query with conditionals
SELECT
id,
CASE WHEN name = "foo" THEN "Foo" ELSE "Bar" END capitalizedName,
height
# ...
You can substitute values in your query with conditionals
SELECT
id,
CASE WHEN name = "foo" THEN "Foo" ELSE "Bar" END capitalizedName,
height
# ...