So, basically, I have this table
+-------------------
|id | col1 | name |
|----|------|------|
| 1 | a | la |
| 2 | b | ria |
| 3 | w | la |
| 4 | q | la |
| 5 | y | ria |
|____|______|______|
And, what I want to do is, I want to get all the data based on id 1, 3 and 5 but with the same name. So, since id 5 is different, and id 1 and 3 is the same, I would like to exclude the id 5. I tried with ...HAVING COUNT(name) >=1
but it only shown 1 data. Is it possible? If so, how to achieve this? Thank you
EDIT: So, what I mean is, I would like to get the result with the same name. Like:
+-------------------
|id | col1 | name |
|----|------|------|
| 1 | a | la |
| 3 | w | la |
|____|______|______|
But, if, for instance in the future, there are case like
"select all data from table where id
[1,2,3,5]
with the same data inname
column"
this will cause a conflict (i guess). the point is, I would like to get the data with the same name where id is given (because I have php app, and the input from the user is only id, and user don't want the different name appear in the result).