SQL to transform all email addresses in my DB in lowercase
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!