MySQL querry

[kafi]

Dear all,

-----Description---------------------------------
I had a problem with migrating database when I had change case sensitive feature to not case sensitive.
I had to change it back to non-sensitive, but meanwhile few of new members where registered and ex-casesensitive usernames now became malign because sometime script treat two usernames as same: Example: OLA and ola is now the same user if it comes to login etc.

I would like to rename those name but first I need to find them out in database.

------Question-----------------------------------------
What will be the sql query in MySQL that will return the list of "same" usernames?

------Thank-You!-----------------------------------