I currently have a db with the fields like this:
db name:Table
user answers
a 1
b 1
c 2
d 2
e 3


how do i select all the columns in the answers that has more than one same values? for example, i want to only select the rows a,b,c,d because their answers have multiple values (1, 2). then i want to group them and count
the number of rows for each group. so in the end, the echo statement should say 2 because a,b is grouped as one and c,d is another group. is it something like:

SELECT answers, COUNT(answers) FROM Table WHERE COUNT(answers)=2 GROUP BY answers ";
$result = mysql_query($query) or die(mysql_error());
$a = mysql_fetch_array($result);
echo "$a";

SELECT answers, COUNT(answers) FROM Table GROUP BY answers HAVING COUNT(answers)=2