MySql REGEXP or RLIKE UPDATE

Asked Feb 19 '16 at 13:32

Active Feb 19 '16 at 14:53

Viewed 75 times

I've been reading some question and I realized that REGEXP or RLIKE doesn't support the UPDATE function, so here's the deal:

I got a table called email_accounts and a column login, in that column there's some data who have some capital letters in the middle of e-mail address, something like this: _clientNAME@domain.com_. All I want is get the capital letters and change to lowercase, considering that the capital letter can be in anywhere before @domain.com

Here's the SELECT that I used: SELECT * FROM contas_emails WHERE CAST(login AS BINARY) RLIKE '[A-Z]';

Thanks!

edited Feb 19 '16 at 14:53

cchapman

3,269
10
50
68

asked Feb 19 '16 at 13:32

Stephen Willians

Use LOWER() function in your SQL queries. More here: http://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_lower – mitkosoft Feb 19 '16 at 13:38
Thhaanks, worked well :D – Stephen Willians Feb 19 '16 at 15:14
@mitkosoft Don't post answers in the comments, post it as a proper answer so you get credit when the OP accepts it and future searchers will know what worked. – Gary_W Feb 19 '16 at 16:08
Sure, I know that :) This was just small suggestion, not a real solution. – mitkosoft Feb 19 '16 at 16:32

MySql REGEXP or RLIKE UPDATE

0 Answers0