Replace Text in Email
Posted on 2011-03-21
I am trying to employ some logic to take the first three characters of an email and replace the rest with some arbitrary value. However, I want to retain the domain. For example,
firstname.lastname@example.org would be changed to email@example.com.
Does anyone know how to use the REPLACE command in MySQL to accomplish this?