How display data in one row from multiple columns in mysql table

Question

i have a table about product review. I saved data in table like this

 id| value|
___|______|
1  |Our pr|
2  |oduct |
3  |availa|
4  |ble in|
5  |all re|
6  |tailer|
7  |shop. |

I want dispaly in one row or paragraph like this Our product available in all retailer shop.

Fahim Parkar · Accepted Answer · 2012-06-19 08:28:08Z

3

You will have to use GROUP_CONCAT as you want to combine data in separate rows.

Try this

SELECT GROUP_CONCAT(value SEPARATOR '') FROM yourtablename

edited Jun 19, 2012 at 8:28

Fahim Parkar

31.8k46 gold badges169 silver badges285 bronze badges

answered Jun 18, 2012 at 15:17

JHS

7,8812 gold badges34 silver badges54 bronze badges

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

1 Comment

Fahim Parkar Over a year ago

@user1464025 : If you think Junaid answered your question please mark it accepted. This is how SO works. See here, how to accept answer

jcho360 · Accepted Answer · 2012-06-18 15:14:34Z

0

try this:

mysql> set @a:=''

mysql> select @a:= concat (@a, ' ', value) from table1.

with that you'll have all the value in @a, and to display

mysql> select @a;

answered Jun 18, 2012 at 15:14

jcho360

3,7491 gold badge18 silver badges25 bronze badges

6 Comments

fancyPants Over a year ago

Wrong. With that you will just have one row at a time in @a

jcho360 Over a year ago

@tombom why you say that? can you tested and let me know your result?

fancyPants Over a year ago

How about you try it? CONCAT operates on rows, GROUP_CONCAT concatenates the strings in one group. Try your query with the test data from the question and you will get nothing but shop. Please edit your answer or delete it or prove me wrong.

fancyPants Over a year ago

And most important, make sure it's right before you post when you're not sure.

jcho360 Over a year ago

@tombom sqlfiddle.com/#!2/a2581/1262, I did another way to display the same result, those are options... please before to say 'edit or delete post' search a little bit about the different solution that a problem can have, if that example is not enough let me know and I'll send you "SQL variables for Dummies"

|

Collectives™ on Stack Overflow

How display data in one row from multiple columns in mysql table

2 Answers 2

1 Comment

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related