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
2 months
0 Answers
9 views
0
Leave an answer
You must login or register to add a new answer .