SQL to transform all email addresses in my DB in lowercase

Question

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!

0
Tommaso 2 months 0 Answers 9 views 0

Leave an answer