Feed Rss



Feb 27 2008

SQL Case Statement

category: Snippets,SQL author:

You can use a case statement in SQL like so:

SELECT
id, `name`, title,
CASE id
WHEN 2 THEN 1
WHEN 3 THEN 1
ELSE 0
END AS selectedCase
FROM table

tag:

One Response to “SQL Case Statement”

  1. ????? says:

    Very NIce

Leave a Reply