Concatenate different rows into one in mysql

Question

I have this database ("statement") where each word of a sentence is in a different row

SENTENCE |  SEQUENCE |  TEXT
    A   |   1       |   MY  
    A   |   2       |   NAME
    A   |   3       |   IS
    A   |   99      |   CARL
    B   |   1       |   MY  
    B   |   2       |   NAME
    B   |   3       |   IS
    B   |   99      |   JUSTINE

I would like to do a select where the result is the complete sentence, like:

 SENTENCE | TEXT
    A   |   MY  NAME IS CARL
    B   |   MY  NAME IS JUSTINE

since I cannot create a new table, I would like to put the command in the select just to have a new column. In each sentence the words are sorted in the column "sequence" and 99 is always the last word of the sentence.

I've tried adapting this solution but it didn't work.

Thank you very much

Turi

The solution you refer to is SQL-Server. MySQL has a whole other SQL syntax — juergen d
– juergen d, Commented Sep 7, 2017 at 10:26

juergen d · Accepted Answer · 2017-09-07 10:24:56Z

1

select sentence, group_concat(text order by sequence separator ' ')
from your_table
group by sentence

answered Sep 7, 2017 at 10:24

juergen d

205k40 gold badges305 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Concatenate different rows into one in mysql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related