kafi
08-22-2006, 09:37 AM
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!-----------------------------------
-----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!-----------------------------------