There is a table with user messages. user_id | message. Can you please tell me how to make a string merge - select all the rows of a single user_id, merge the message field, create one new string, and delete the old ones? Tried to do with GROUP_CONCAT, but it does not work.

  • What does "merge message field" mean? And most importantly, why? - vp_arth
  • type concatenation - Vlad
  • Will then be used these messages separately? Or not? Why does the user have just one message? So conceived? - vp_arth
  • SELECT GROUP_CONCAT ( message SEPARATOR ',') FROM table WHERE user_id = xxx - Vlad
  • just create a new line and delete old ones. - Vlad

0