组合句子成为1个字符串

Question

I have a table in database :

---------------------------------------
- id - fileid -        sentences      -
---------------------------------------
- 1 -     1   -   I want eat .        -
- 2 -     1   -   I wanna eat banan . -
- 3 -     2   -   I wanna eat apple . -
- 4 -     2   -   I wanna sleep .     -
---------------------------------------

I wanna collect sentences depends on 'fileid'. So the result is :

I want eat .  I wanna eat banan .

and

I wanna eat apple . I wanna sleep .

how to do that with assumption i don't know the fileid? thanks

Answer 1

I think you just want group_concat():

select group_concat(sentences order by id separator '')
from table t
group by fileid