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-12T09:45:03.357

2

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

edited Sep 12 '13 at 09:45

answered Sep 12 '13 at 09:39

Deepanshu Goyal

score 1 · Answer 2 · answered Sep 12 '13 at 09:38

1

try

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

answered Sep 12 '13 at 09:38

developerCK

score -1 · Answer 3 · edited Sep 13 '13 at 09:22

-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 '13 at 09:22

Alex

answered Sep 12 '13 at 12:50

Dawit

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) – Alex Sep 13 '13 at 09:24

3 Answers3