Possible to run a regex from within a sql query?
Posted: Wed Feb 16, 2005 3:02 pm
I have some content from an LMS here that has our old domain in it that I need to just replace with our new domain (for img references and hrefs).
is it possible to do a "search" on the table field for the old domain and replace it with the new domain?
my alternative is to export the data, open a text editor and do a find and replace there, then re-import the data.
I'd like to avoid that if possible.
Burr
is it possible to do a "search" on the table field for the old domain and replace it with the new domain?
my alternative is to export the data, open a text editor and do a find and replace there, then re-import the data.
I'd like to avoid that if possible.
Burr