Jump to content

How do I combine all rows into one row, while controlling the seperator?


Recommended Posts

Hi phpfreaks,

I use the normal ol' MySQL 5.0

I was wondering if there's a way to gather all of a single column's row into one row.

For example:

ROW

Hi

This

Is

Me

 

What I want to do is merge them into one row with the ability to control the seperator, like:

Hi:This:Is:Me

 

I searched for an answer and only came up with "GROUP_CONCAT", but this doesn't seem to allow the control of the seperator... it always has a "," as it.

 

Regards.

Hi phpfreaks,

Ah! Thanks. I was also wondering: Is it possible to do a WHERE statement to check if something is there and if it's there, it'll be replaced by ":"?

Example:

ROW

Hi

This

Is

Me

 

I want to gather all of that except for... "Is". Which should return:

Hi:This::Me

Hi phpfreaks,

Thanks again!

But what if I wanted to replace a certain one?

Example:

ROW

Hi

This is Poff

This is Poff Again

What's up?

 

I want to replace the words "This is Poff" but NOT "This is Poff Again" to ":".

 

Regards.

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.