get single column from multiple rows in mysql

Question

i have two rows as show in below image.i want to get it as a single column based on aday(TUE) in the table,please any help me how to workout this. thanks in advance

enter image description here

Post your sql please. Also, are you looking for a single column or single row? Single row is LIMIT 1 and column is just SELECT aday FROM ... — Martin Wickman
– Martin Wickman, Commented May 27, 2014 at 11:29
Where does your question relate to Java? Do you want to just merge those 2 rows into a single row or do you want to do some magic in SQL (i.e. concatenation) to return a single column. Please edit your question to be more precise. — Norbert Radyk
– Norbert Radyk, Commented May 27, 2014 at 11:30
what is your expectation? explain output with above example. — Sanjeev
– Sanjeev, Commented May 27, 2014 at 11:43

Kickstart · Accepted Answer · 2014-05-27 12:02:04Z

2

You can't as that would give variable numbers of columns for the rows returned.

You can do a fiddle with GROUP_CONCAT:-

SELECT doctorname, aday, GROUP_CONCAT(CONCAT_WS('~', availfrom, availupto) SEPARATOR '#') avail_time_slots
FROM sometable
GROUP BY doctname, aday

Then in code you would need to split up the avail_time_slots

answered May 27, 2014 at 12:02

Kickstart

21.5k2 gold badges26 silver badges33 bronze badges

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

2 Comments

DurgaPrasad Ganti Over a year ago

thank its working fine,now i am trying to split avail_time_slots.while displaying it show some hash code like [B@43H40 like that, i am using jstl code like <c:out value="${row.avail_time_slots}"/> .what is the mistake i don't know i database console it gives correctly

Kickstart Over a year ago

I am afraid my Java knowledge is poor and out of date so not sure how you would split that up in Java (in php it is simple).

MooseElkingtons · Accepted Answer · 2014-05-27 11:33:04Z

0

This question isn't related to java, but rather SQL queries. You could select all in a table, and only return rows where column aday has the value "TUE".

SELECT * FROM table WHERE aday=TUE

answered May 27, 2014 at 11:33

MooseElkingtons

72 bronze badges

3 Comments

DurgaPrasad Ganti Over a year ago

this query gives two rows,but i want to display one rows with all data without duplicatedata

MooseElkingtons Over a year ago

is there a particular row you want, or does it not matter? You could have multiple conditions relating to other columns and their values. If you just want the first row to be returned, do SELECT * FROM table WHERE aday=TUE LIMIT 1

DurgaPrasad Ganti Over a year ago

i need both rows data(availfrom ,availupto) in a single column, i edit my question what i am getting currently in front end. i want to display 2nd row availfrom ,availupto beside the first row

Collectives™ on Stack Overflow

get single column from multiple rows in mysql

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related