plecostomus
asked on
Replace Text in Email
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,
thisismyemail@yahoo.com would be changed to thitest123@yahoo.com.
Does anyone know how to use the REPLACE command in MySQL to accomplish this?
thisismyemail@yahoo.com would be changed to thitest123@yahoo.com.
Does anyone know how to use the REPLACE command in MySQL to accomplish this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.