[thelist] SQL partial string replace

David McCreath mccreath at kadmium.net
Fri Jan 10 14:34:01 CST 2003


Hola, 'volta --

I've got one of those problems that I can't find an answer to because
I'm not even sure exactly how to ask it.

I need to change the domain name for a bunch of email addresses in a
MySQL database (asd.k12.ak.us -> asdk12.org), and I can't find anything
about how to do it. Is there some kind of pattern matching syntax in
SQL? I can *find* all the addresses, and I could update them
individually, but that seems silly.

thanks
David




More information about the thelist mailing list