Re: [sqlite] Seasonal syntax

2017-12-15 Thread Peter Da Silva
SELECT name, address CASE behaviour WHEN 'nice' THEN SELECT toy FROM stocking_stuffers ORDER BY random() LIMIT 1 WHEN 'naughty' THEN 'coal' ELSE phnglui mgwlnafth cthulhu END ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Seasonal syntax

2017-12-14 Thread Rowan Worth
On 14 December 2017 at 01:19, Warren Young wrote: > On Dec 12, 2017, at 10:24 AM, Simon Slavin wrote: > > > > Santa Clause: SELECT name,hobbies,address FROM people WHERE > behaviour=‘nice’ > > I think you mean > > SELECT name,address > CASE

Re: [sqlite] Seasonal syntax

2017-12-13 Thread Warren Young
On Dec 12, 2017, at 10:24 AM, Simon Slavin 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'

Re: [sqlite] Seasonal syntax

2017-12-12 Thread Stephen Chrzanowski
You had to do that just beclause On Tue, Dec 12, 2017 at 12:24 PM, Simon Slavin wrote: > Some SQL terminology: > > Selection Clause: WHERE >Sort Clause: ORDER BY > Sublist Clause: LIMIT OFFSET > Subsort Clause: GROUP BY HAVING > Santa