Re: [sqlite] OT!!!!! Understanding the WITH clause

2019-06-21 Thread Luuk
On 20-6-2019 08:11, Michael Falconer wrote: SELECT peace FROM disaster WHERE disaster.cause = 'Windows'; Returns: *nix The query should be SELECT peace FROM disaster WHERE (disaster.cause LIKE '%Windows%' OR disaster.cause LIKE '%nix%' OR disaster.cause LIKE '%incompetence%'

Re: [sqlite] OT!!!!! Understanding the WITH clause

2019-06-20 Thread Michael Falconer
SELECT peace FROM disaster WHERE disaster.cause = 'Windows'; Returns: *nix On Thu, 20 Jun 2019 at 14:26, Sam Carleton wrote: > James, > > That is a really, really interesting quote. it really got me thinking > about peace and the definition of it. It got me thinking so much I wanted > to

Re: [sqlite] OT!!!!! Understanding the WITH clause

2019-06-19 Thread Sam Carleton
James, That is a really, really interesting quote. it really got me thinking about peace and the definition of it. It got me thinking so much I wanted to know the context of the sentence, so I went looking for it in Letter from the Birmingham Jail, this is my source link (