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
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
> >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
> > > 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