mysql - concatenate strings of rows according to column -


i hava table

msgid    msg              value ms001    here.       ---- ms001    wher     dsdad ms002    r u          gfsdfdf ms002       dadad ms002    goin        adadad 

is possible result mysql query

ms001    here. wher ms002    r u wher goin   

read group_concat

select msgid , group_concat(msg separator ' ') msg table1 group msgid; 

sql fiddle


Comments

Popular posts from this blog

basic authentication with http post params android -

vb.net - Virtual Keyboard commands -

How to get multiresult with multicondition in Sql Server -