I have a MySql data base with a 'user.email' field. I want to update the table to remove everything before the @ symbol so I am just left with a column of email domains. Can't seem to get me query to run. Any help is appreciated!
Keep everything after '@'
UPDATE users SET email = SUBSTR(email,LOCATE('@',email) + 1)
WHERE LOCATE('@',email) > 0;
Keep everything starting '@'
UPDATE users SET email = SUBSTR(email,LOCATE('@',email))
WHERE LOCATE('@',email) > 0;
Assuming your table name is USERS and has EMAIL as column
Before update your email column data would be like [email protected] [email protected]
update users SET email=replace(email,left(email, INSTR(email, '@')-1),'');
After update xyz.com syz.com
If you do not need the @ symbol in the domain then remove '-1' from the query
Try this:
select right(email, charindex('@', reverse(email)) - 1)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With