There is a table (let its name be schedule) of the form:

  [id] [hour] [minutes]  
 [1] [6] [35]
 [2] [7] [15]
 [3] [7] [35]
 [4] [8] [10]
 [5] [9] [50]
 [6] [9] [55] 

I need to merge those rows in which the hour column matches.
What query do you need to perform on this table to get this result ?:

  [id] [hour] [minutes]  
 [1] [6] [35]
 [2] [7] [15 35]
 [3] [8] [10]
 [4] [9] [50 55] 

    1 answer 1

    SELECT id, hour, GROUP_CONCAT(munites, " ") FROM table GROUP_BY(hour) 
    • Thank you very much, what you need! - drojjipivnie