How about this ...
update schedule s
join directory d on s.email = replace(d.email, '@wnc.edu', '@wncc.edu')
set s.email=replace(s.email, '@wncc.edu', '@wnc.edu' );
PB
-
Kevin Murphy wrote:
I'm trying to do a join on two pieces of data that are not quite
exactly the same. Basic story, I h
I'm trying to do a join on two pieces of data that are not quite
exactly the same. Basic story, I have 2 tables (output from 2
mainframes) in MySQL where one table has our email addresses as
@wncc.edu (our old name) and the other has it as @wnc.edu (our new
name). So here is an abbreviated