Getting multiple values in a single MySQL query

Question

If I have a table that lists names and ages then can I run a single query that will give me all names of people with a particular age.

e.g.

name      age
----------|-------
alice      20
bob        21
chris      20
dave       23
eric       26
fred       29
greg       20

I want my query to return a list, separated by a comma, of all people who are aged 20.

e.g.

select (concat(name,',')) from people where age='20'

And this outputs:

alice,chris,greg

Obviously I could just do:

select name from people where age='20'

And then loop through the results in PHP but I am trying to do all of this in a query

Deepanshu Goyal · Accepted Answer · 2013-09-12 09:45:03Z

2

select GROUP_CONCAT(name) AS name from people where age='20'

edited Sep 12, 2013 at 9:45

answered Sep 12, 2013 at 9:39

Deepanshu Goyal

2,8413 gold badges38 silver badges63 bronze badges

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

Comments

developerCK · Accepted Answer · 2013-09-12 09:38:32Z

1

try

select GROUP_CONCAT(name) from people where age='20'

answered Sep 12, 2013 at 9:38

developerCK

4,5263 gold badges19 silver badges35 bronze badges

Comments

Alex · Accepted Answer · 2013-09-13 09:22:34Z

-1

Try this:

SELECT name
FROM people
WHERE age='20'
INTO OUTFILE '/tmp/name.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'

edited Sep 13, 2013 at 9:22

Alex

35.7k20 gold badges115 silver badges202 bronze badges

answered Sep 12, 2013 at 12:50

Dawit

113 bronze badges

1 Comment

Alex Over a year ago

interesting approach - not sure if it work - but incomplete: how to get the file back into PHP? (anyways - I think the accepted answer is much easier)

Collectives™ on Stack Overflow

Getting multiple values in a single MySQL query

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related