php get records from mysql only when dosent have duplicated value

Viewed 24

mysql like that

=======================
| id    |  name       |
| 1     | jhon        |  
| 2     | sarah       |
| 3     | suzan       |
| 4     | jhon        |
| 5     | ahmed       |
=======================

my expected result is

sarah
suszan
ahmed

want to remove jhon or any value name are duplicated i tried to use

SELECT * FROM  table WHERE id={$id} GROUP BY name

but it's only displaying the duplicated values

2 Answers
Related