On 14 December 2017 at 01:19, Warren Young <[email protected]> wrote:
> 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 > Surely "hobbies" should read something like: (SELECT gift FROM ideas WHERE ideas.hobby IN (SELECT value FROM json_each(hobbies)) ORDER BY random() LIMIT 1) -Rowan _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
