title: Mysql-how to update the "domain.com" in "address@domain.com"
body: <p>In my database I have a lot of users who've misspelled their e-mail address. This in turn causes my postfix to bounce a lot of mails when sending the newsletter.<br>
  Forms include (but are not limited to) "yaho.com", "yahho .com" etc.<br>
  Very annoying!</p>
  
  <p>So i have been trying to update those record to the correct value.<br>
  After executing <code>select email from users where email like '%@yaho%' and email not like '%yahoo%';</code> and getting the list, I'm stuck because I do not know how to update only the <code>yaho</code> part. I need the username to be left intact.</p>
  
  <p>So I thought I would just dump the database and use vim to replace, but I cannot escape the <code>@</code> symbol..</p>
  
  <p>BTW, how do I select all email addresses written in CAPS? <code>select upper(email) from users;</code> would just transform everything into CAPS, whereas I just needed to find out the already-written-in-CAPS mails.</p>