MySQL query to change domain of all email addresses in a field

I have a `users` table with a field called emailaddress with about 1500 records... each of them has the same domain associated with it..

user1@dallasray.com
user2@dallasray.com
user3@dallasray.com

We are switching to a new domain so how can I write a query that was find all instances of @dallasray.com and replace them with @southtexastech.com  ?

user1@southtexastech.com
user2@southtexastech.com
user3@southtexastech.com

etc.

thank you!
LVL 2
smetterdAsked:
Who is Participating?
 
Cornelia YoderConnect With a Mentor ArtistCommented:
UPDATE users SET emailaddress=REPLACE(emailaddress,'@dallasray.com','@southtexastech.com')
0
All Courses

From novice to tech pro — start learning today.