Comma Separated

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • yasmine
    New Member
    • Feb 2008
    • 64

    #16
    The Correct code to do it is as follows:

    [CODE=mysql]CREATE TABLE a (SELECT content, cast( group_concat( survey_id ) AS char ) , count( * ) count FROM b GROUP BY content ORDER BY count DESC LIMIT 30[/CODE]

    Thanx n Regards
    Yas..

    Comment

    Working...