splitting mysql result into seperate username with comma

Discussion in 'MySQL' started by EV1L, Sep 23, 2007.

  1. #1
    Hi guys,

    You see I'm trying to clean up my user database, by checking the last login time of my users. I got the results - all the usernames.

    My question is how can I display the results with comma between each username?


    SQL query:
    SELECT `username`
    FROM `u_users`
    WHERE `is_activated` =1
    AND `last_login_time` <1185926400
    ORDER BY `userid` ASC
    LIMIT 0 , 50
     
    EV1L, Sep 23, 2007 IP
  2. krt

    krt Well-Known Member

    Messages:
    829
    Likes Received:
    38
    Best Answers:
    0
    Trophy Points:
    120
    #2
    SELECT CONCAT(`username`, ',')
    ...
     
    krt, Sep 23, 2007 IP
  3. EV1L

    EV1L Well-Known Member

    Messages:
    184
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    103
    #3
    thanks a lot!
     
    EV1L, Sep 23, 2007 IP