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 again, but
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? Do you
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 is en,sv,no the