<div>
<div class="content wysiwyg-content">
I have a `users` table with a field called emailaddress with about 1500 records... each of them has the same domain associated with it..<br />
<br />
user1@dallasray.com<br />
user2@dallasray.com<br />
user3@dallasray.com<br />
<br />
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 &nbsp;?<br />
<br />
user1@southtexastech.com<br />
user2@southtexastech.com<br />
user3@southtexastech.com<br />
<br />
etc.<br />
<br />
thank you!
</div>
</div>


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!

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

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.