How to combine two column of text using python sql

Question

id    fk_case_id      content
1        468          This is to inform the record
2        468          tommorrow for studies
3        469          Hello welcome to school

from connect_database import mycursor,db
mycursor.execute(f"select content,pk_content_id,fk_case_id from mt_page_file_contents")
myresult = mycursor.fetchall()
for x in myresult:
    text = x[0]

I need to join column row 1 and 2 based on unique fk_case_id and get solution "This is to inform the record tommorrow for studies". Is there any solution

vikas soni · Accepted Answer · 2021-09-30 10:28:18Z

1

You can try this.

Postgres:

SELECT fk_case_id, string_agg(content, ' ') as contents
FROM mt_page_file_contents
GROUP BY fk_case_id;

MySQL:

SELECT fk_case_id, GROUP_CONCAT(content, " ") as contents
FROM mt_page_file_contents
Group by fk_case_id;

This will give you concatenated content by grouping on the basis of fk_case_id.

fk_case_id      contents
   468          This is to inform the record tommorrow for studies
   469          Hello welcome to school

edited Sep 30, 2021 at 10:28

answered Sep 30, 2021 at 10:22

vikas soni

6084 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

How to combine two column of text using python sql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related