On Wed, May 21, 2014 at 6:00 PM, Humblebee <fantasia.d...@gmail.com> wrote:
> | 1 | 4 | 1,5,2,3,4 | > | 2 | 5 | 2,6,3,5,1 | > +----------------------------------| > ... > @Simon, thank you for showing me a better way to setup the tables, > Without doing what Simon suggests, there is no good solution to your problem with the data structure you have. SQL is made for normalized data, not strings containing arbitrary tokens separated by arbitrary other tokens. > your way makes much more sense, only problem is that in this > situation, the tables have already been defined and made by someone > else so I cannot change it. I'm a bit stuck with the way it is. > Then you're stuck with the problem you've got. -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
