Re: [sqlite] Get a specific sequence of rows...

2010-03-26 Thread Fredrik Karlsson
On Fri, Mar 26, 2010 at 1:25 PM, Igor Tandetnik wrote: > Fredrik Karlsson wrote: >> This is of course another solution. I guess, coming from R, I was >> looking for a substitute for th %in% operator (or the MySQL IN >> operator as it turns out, now that I've Googled this some more) but a >> temp t

Re: [sqlite] Get a specific sequence of rows...

2010-03-26 Thread Gabor Grothendieck
On Fri, Mar 26, 2010 at 5:00 AM, Fredrik Karlsson wrote: > Hi, > > I have a list of id:s stored in a field. I would now like to get some > information from a table by these id:s, but exactly in this order. So, > if I have a table > > 1 One > 2 Two > 3 Three > > and the sequence "3,1,2" stored some

Re: [sqlite] Get a specific sequence of rows...

2010-03-26 Thread Igor Tandetnik
Fredrik Karlsson wrote: > This is of course another solution. I guess, coming from R, I was > looking for a substitute for th %in% operator (or the MySQL IN > operator as it turns out, now that I've Googled this some more) but a > temp table would also do the trick I guess. Well, you can generate

Re: [sqlite] Get a specific sequence of rows...

2010-03-26 Thread Fredrik Karlsson
On Fri, Mar 26, 2010 at 12:22 PM, Simon Slavin wrote: > > On 26 Mar 2010, at 9:00am, Fredrik Karlsson wrote: > >> I have a list of id:s stored in a field. I would now like to get some >> information from a table by these id:s, but exactly in this order. So, >> if I have a table >> >> 1 One >> 2 Tw

Re: [sqlite] Get a specific sequence of rows...

2010-03-26 Thread Simon Slavin
On 26 Mar 2010, at 9:00am, Fredrik Karlsson wrote: > I have a list of id:s stored in a field. I would now like to get some > information from a table by these id:s, but exactly in this order. So, > if I have a table > > 1 One > 2 Two > 3 Three > > and the sequence "3,1,2" stored somewhere, how

Re: [sqlite] Get a specific sequence of rows...

2010-03-26 Thread David Bicking
On Fri, 2010-03-26 at 10:00 +0100, Fredrik Karlsson wrote: > Hi, > > I have a list of id:s stored in a field. I would now like to get some > information from a table by these id:s, but exactly in this order. So, > if I have a table > > 1 One > 2 Two > 3 Three > > and the sequence "3,1,2" stored