MYSQL question

[dexter_sherban]

I want to take every entry in a column and see if there is any entry with the same value in that column.If yes I want to  remember the value of that entry and store it into a varriable.

 

Does anyone know how to do that ?

[monk.e.boy]

do something like:

 

select my_val, count(id) as c from table group by my_val

 

So if the table had:

 

1,me

2,me,

3,you

 

and the output would be:

 

me,2

you,1

 

monk.e.boy