-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by TULMER
-
-
updatetext
in SQL
I need to update over 400 email address in a table in the database. I need to keep the first half of the email address and change everything after the '@' symbol.
Example: FROM: john.doe@oldname.com -- TO: john.don@newcompanyname.com
Is there any easy way?
updatetext
in SQL
Posted
didn't work -- only replaces complete email address with the field name:
UPDATE cicntp
SET cnt_email = REPLACE ('cnt_email', 'oldname.com', 'newcompanyname.com')
WHERE (cnt_email LIKE '%@oldname.com')
___ results are email address goes to "cnt_email" and nothing more.