Skip to content

Instantly share code, notes, and snippets.

@buihuynhhung

buihuynhhung/Thay đuôi email trong mysql

Created February 12, 2019 08:41
Show Gist options
  • Save buihuynhhung/59145dc1e9f23afc71c164e005ff7e89 to your computer and use it in GitHub Desktop.
Save buihuynhhung/59145dc1e9f23afc71c164e005ff7e89 to your computer and use it in GitHub Desktop.
Download ZIP
Thay thế đuôi email hàng loạt trong bảng của mysql
Raw
Thay đuôi email trong mysql
UPDATE `member`
SET `member_email` = CONCAT(LEFT(`member_email`,INSTR(member_email,'@')),'cybridge.jp');
WHERE member_email LIKE '%@cybridge.jp%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment