sql - Oracle Update table to set specific attribute value in semicolon separated values -

i have column have values like:

email_password+oi8hu907b;new_email+y;email_username+iugbhijhb8 

now want update new_email attribute rows has y n without affecting else.

please advise.

i hate but...

update table    set column = replace(column,'new_email+y','new_email+n') column '%new_email+y%' 

you don't need clause if put functional index on table may quicker it