Array from mysql

Question

I have a table in MySQL with two columns.

Name  Surname
Mark  A
Mark  B
Mark  C
Jonh  A
John  B
Mark  D
Dean  A

If I will make SELECT FROM query and ask only for names column i will have an array looking like this:

Mark,Mark,Mark,Jonh,Jonh,Mark,Dean

And I want an array looking like this

Mark,John,Dean

How can I do it with PHP or MySQL?

Alternatively and suboptimally there's also [`array_unique`](http://php.net/array_unique) in PHP. — mario, Jun 14 '14 at 01:32

score 3 · Accepted Answer · answered Jun 14 '14 at 01:29

3

DISTINCT specifies removal of duplicate rows from the result set.

SELECT DISTINCT `Name` FROM tablename

answered Jun 14 '14 at 01:29

John Conde

As you were preparing this, I was typing it as a comment lol – Funk Forty Niner Jun 14 '14 at 01:29
1

Great minds think alike! – John Conde Jun 14 '14 at 01:31
True.... Funny, I was going to say the same thing in an edit, but you beat me to it lol ;-) – Funk Forty Niner Jun 14 '14 at 01:31
Pefect solution, thank you :) – MateuszC Jun 14 '14 at 01:32
@MateuszC Do tick that little checkmark till she turns Green then ;-) – Funk Forty Niner Jun 16 '14 at 15:48

1 Answers1