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
# ...