Re: [sqlite] Seasonal syntax

[Warren Young]

On Dec 12, 2017, at 10:24 AM, Simon Slavin <slav...@bigfraud.org> wrote:
> 
>      Santa Clause: SELECT name,hobbies,address FROM people WHERE 
> behaviour=‘nice’

I think you mean

    SELECT name,address 
    CASE behaviour
      WHEN ‘nice' THEN
        hobbies
      ELSE
        'coal'
      END
    FROM people

_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users