On Dec 12, 2017, at 10:24 AM, Simon Slavin <[email protected]> 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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
