MySql return only one instance of duplicate entries

Question

Hi I have a table with names and numbers entered along with other data . The table called events contains many instances where the name and numbers are the same but the other entries are different. I want to perform a search using names so I can display the number. But in my search I only need to return one instance of a name . The table is like this

        Name    Number  Responisble     Position

        Paul    8455    Chorley     t7
        Dave    3821    PR south    f5
        Paul    8455    PR North    p9
        Paul    8455    Leyland     t6
        Dave    3821    Ribbleton   r4

and my script is this

    $condition = "name LIKE 'Paul' ";
    $result = mysql_query("SELECT * FROM events WHERE $condition ")  ;

     while($row = mysql_fetch_array($result)) {

The script is not complete but I hope you can see that the results would return 3 results but what i want is a result with just one for each name

I hope this makes sense ! thanks for any help

jatt · Accepted Answer · 2010-10-08 13:13:31Z

3

$condition = "name LIKE 'Paul' ";
$result = mysql_query("SELECT * FROM events WHERE $condition GROUP BY name")  ;

answered Oct 8, 2010 at 13:13

jatt

3981 silver badge5 bronze badges

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

Comments

Ross · Accepted Answer · 2010-10-08 13:12:41Z

1

try using distinct -

SELECT DISTINCT (columns) FROM (table) WHERE (condition)

edit probably disregard this, mis-understood your question i think

MySql return only one instance of duplicate entries

answered Oct 8, 2010 at 13:12

Ross

18k7 gold badges46 silver badges65 bronze badges

Comments

Rwky · Accepted Answer · 2010-10-08 13:13:52Z

0

You can either use group by or distinct in the select statement see http://dev.mysql.com/doc/refman/5.1/en/select.html

In your example it would be

$condition = "name LIKE 'Paul' ";
$result = mysql_query("SELECT * FROM events WHERE $condition GROUP BY name")  ;

 while($row = mysql_fetch_array($result)) {

answered Oct 8, 2010 at 13:13

Rwky

2,1541 gold badge18 silver badges22 bronze badges

Comments

Thomas · Accepted Answer · 2010-10-08 13:14:01Z

0

SELECT name, number FROM events WHERE $condition GROUP BY name, number

answered Oct 8, 2010 at 13:14

Thomas

2,1521 gold badge13 silver badges10 bronze badges

Collectives™ on Stack Overflow

MySql return only one instance of duplicate entries

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related