I have what I hope is a simple problem, but being somewhat a novice at MySQL, it is a bit beyond me.
I have a database that has a emailaddress field. A large number of the entries are from home.com, Excite's ISP. Since Excite is out of business, Comcast is converting them all to comcast.net next month. Is there a simple way to change all home.coms to comcast.nets while retaining the front part of each email address in our database? A link to the pertinent section of the manual would be most helpful. -- Greg Peretti web developer www.abqjournal.com (505) 823-3888 ----------------------------------- The web of our life is of a mingled yarn, good and ill together. - William Shakespeare --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php