MySQL Forums
Forum List  »  MySQL Query Browser

Is there a way to make the values in one column split out into their own columns
Posted by: Jamie Gagnon
Date: October 03, 2013 11:46AM

Hi Iam very new to Mysql

I have a database that I am building a report from.

The base has a status column of which refers to status such as 10, 20 30 0.

The bug tracking tool (which unfortunately does not have reporting) does not hold the true values of the statuses, But I know 10 is New 20 is Feedback so forth and so on.

What I am trying to do is make a query that will look at the bug table, locate column for status read the values of that column but return the results of the query as a column of New with all the 10's under it, a column with Feedback as its name with all the 20's under it and so on.

I have been trying sub queries but getting no where.

can anyone provide any pointers?

I know the basics i can do Joins etc. I am just stuc with how best to do this


Example

Status
10
10
20
10
20

What I want is

New|Feedback
10 20
10 20
10

Options: ReplyQuote


Subject
Written By
Posted
Is there a way to make the values in one column split out into their own columns
October 03, 2013 11:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.