Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
  1. #1
    Senior Coder
    Join Date
    Dec 2005
    Location
    Slovenia
    Posts
    1,963
    Thanks
    120
    Thanked 76 Times in 76 Posts

    group_concat... order by

    EDIT: Had multiple joins owerlooked something, this works as expected, so no need to look at thread.

    data:
    Code:
    a                        b  
    
    "modrikasta golobica"	"1"
    "ženska golobica"   	"9"
    "vijoličasta golobica"	"9"
    "sivkica"               "9"
    "sivka"                	"9"
    "plavka"              	"9"
    Code:
    group_concat(distinct a order by b )
    --> plavka,ženska golobica,modrikasta golobica,vijoličasta golobica,sivka,sivkica

    I would expect "modrikasta golobica" first. ?
    Table & column colation is ok, according to "a" column contence.
    "b" is type SMALLINT
    Last edited by BubikolRamios; 10-13-2013 at 08:03 PM.
    Found a flower or bug and don't know what it is ?
    agrozoo.net galery
    if you don't spot search button at once, there is search form:
    agrozoo.net galery search


 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •