update email address

From: Sheela <spathiyal_at_yahoo.ca>
Date: 5 Apr 2005 13:55:02 -0700
Message-ID: <678ae5f9.0504051255.1fdbf3c@posting.google.com>

Hi there,
I would like to update 5000 email address from

name_at_xxxxxx.com to name_at_yyyyy.com.
name1_at_xxxxxx.com to name1_at_yyyyy.com

---

---

---

I tried this statment :
update student a set
substr(a.email_addr,(instr(a.email_addr,'@')+1),10) = 'yyyyy.com'where stud_id like 'name'

but I am getting ORA-00927: missing equal sign

How I can do that using update statment?

Thanks Received on Tue Apr 05 2005 - 15:55:02 CDT