Re: order by, group by

2001-11-13 Thread Christan Andersson
Looks like no one knows the answer to this question... - Original Message - From: "Christian Andersson" <[EMAIL PROTECTED]> To: "MySQL Mailing list" <[EMAIL PROTECTED]> Sent: Monday, November 12, 2001 10:30 PM Subject: order by, group by > I asked before, but got no answer, so I ask aga

Re: order by, group by

2001-11-13 Thread Christan Andersson
Im trying to make a "data" system that is language-independent, ie the data stored can have any language therefore the same information is stored several times but with different values (depending on language) lets say that I have this table.. articles(id,language,name,description) what I would

Re: order by, group by

2001-11-13 Thread Christan Andersson
> >will return all articles even if they do not have an english translation, > >BUT here is the problem.. which language will be the one I recieve? > >Svedish? english? French? > > > There seems to be a little confusion here regarding grouping and > ordering. What do you mean by "the one I receive

Re: order by, group by

2001-11-13 Thread Christan Andersson
> > > 1'en''blue circle''this is a blue ' > > > 1'no''bla cirkel' 'dette er ei bla cirkel' > > > 2'en''green leaf' 'this is a green leaf from a tree' > > > 2'sv''grönt löv' 'detta är ett grönt löv från ett träd' > > > > > > if the language priority