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 do I get a neat list like > > Three > One > Two
I can't find a function which does what you want. The SQL-like solution to it is to have your '3,1,2' written to a table as three records, then use a JOIN or a sub-SELECT to make SQL return the right records in the right order. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
