Re: MySQL search/replace. help please

2000-09-07 Thread Christian Hammers
On Thu, 07.09.00 18:59 +, t s a d i wrote: > hello gang! yo man! > what i need to do is to search out all occurences of the string > "www.olddomain.com" and change it to "www.mynewdomain.com". Well, I go the simple way for this problems: mysqldump --opt database table \ | sed 's/oldstrin

Re: MySQL search/replace. help please

2000-09-07 Thread Christian Hammers
On Thu, 07.09.00 18:59 +, t s a d i wrote: > hello gang! yo man! > what i need to do is to search out all occurences of the string > "www.olddomain.com" and change it to "www.mynewdomain.com". Well, I go the simple way for this problems: mysqldump --opt database table \ | sed 's/oldstri

MySQL search/replace. help please

2000-09-07 Thread t s a d i
hello gang! i have a column in my table called "pagetext" w/c contains a _lot_ of data in it (its the column containing the data for posts made on a message board). what i need to do is to search out all occurences of the string "www.olddomain.com" and change it to "www.mynewdomain.com". hope

MySQL search/replace. help please

2000-09-07 Thread t s a d i
hello gang! i have a column in my table called "pagetext" w/c contains a _lot_ of data in it (its the column containing the data for posts made on a message board). what i need to do is to search out all occurences of the string "www.olddomain.com" and change it to "www.mynewdomain.com".