Simple CASE

Learn the simple CASE form.

Simple CASE compares one expression for equality. It is a shorter form of searched CASE.

SELECT name,
  CASE category WHEN 'Kitap' THEN 'okuma'
       WHEN 'Elektronik' THEN 'teknik'
       ELSE 'diğer' END AS type
FROM products;

This query converts the category name to a type.

name, CASE category WHEN 'Kitap' THEN 'okuma' WHEN … is selected from products.

Simple CASE — details

In simple CASE the CASE expression is written once; each WHEN checks equality with a value.

For example, CASE status WHEN 'A' THEN 'Aktif' WHEN 'P' THEN 'Pasif' END turns codes into readable text.

Write CASE category WHEN 'Kitap' THEN 'okuma' ... END to convert category to type.

Show example solution

SELECT name,
  CASE category WHEN 'Kitap' THEN 'okuma'
       WHEN 'Elektronik' THEN 'teknik'
       ELSE 'diğer' END AS type
FROM products;

Add category

CASE ____ WHEN 'Kitap' THEN 'okuma'

Show answer

CASE category WHEN 'Kitap' THEN 'okuma'