CASE WHEN - prayagupa/rdb GitHub Wiki

SELECT 
  (CASE WHEN x='refrigerators' THEN 1 
  WHEN x='Tv' THEN 2 
  ELSE 3 END) as num
FROM (SELECT "refrigerators" AS x, "Tv" as y) 

SELECT 
  (CASE WHEN x=y THEN 1 ELSE 0 END) as matches
FROM (SELECT "refrigerators" AS x, "Tv" as y) 


SELECT 
  (CASE WHEN x=y THEN 1 ELSE 0 END) as matches
FROM (SELECT "refrigerators" AS x, "refrigerators" as y)