php get records from mysql only when dosent have duplicated value

Question

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

Talgat · Accepted Answer · 2017-08-16 03:08:34Z

2

Use HAVING

SELECT `name` FROM `table` GROUP BY `name` HAVING COUNT(`name`) = 1

edited Aug 16, 2017 at 3:08

answered Aug 16, 2017 at 3:01

Talgat

3141 gold badge2 silver badges5 bronze badges

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

Comments

Hooda · Accepted Answer · 2017-08-16 05:38:37Z

0

To get unique values, you can use below :

// This will return unique values

SELECT DISTINCT `name` FROM `table`;

answered Aug 16, 2017 at 5:38

Hooda

1,2071 gold badge10 silver badges17 bronze badges

1 Comment

Black Mamba Over a year ago

He's not asking for distinct but for name having count 1 as in @Talgat answer

Collectives™ on Stack Overflow

php get records from mysql only when dosent have duplicated value

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related