Sql conditionals

From wikinotes
Revision as of 13:58, 3 August 2022 by Will (talk | contribs) (Created page with "You can substitute values in your query with conditionals <syntaxhighlight lang="sql"> SELECT id, CASE WHEN name = "foo" THEN "Foo" ELSE "Bar" END capitalizedName, height # ... </syntaxhighlight>")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

You can substitute values in your query with conditionals

SELECT
  id,
  CASE WHEN name = "foo" THEN "Foo" ELSE "Bar" END capitalizedName,
  height
# ...