how can I transform all email addresses in my DB in lowercase?

I did an import and all addresses are uppercase and if a user registers again with lowercase the system thinks is another email. So I want to change all the emails to lower to avoid further duplications.

best will be to have a SQL query to do that

Thanks for your help!