On Thu, Oct 9, 2008 at 4:21 PM, mike cantor <[EMAIL PROTECTED]> wrote:
> Does anyone know of a utility that can go through a set of tables (or every
> table) in a MySql database and preform a global search and replace (i.e.
> replace every instance "string1" in a text fiel
Does anyone know of a utility that can go through a set of tables (or
every table) in a MySql database and preform a global search and replace
(i.e. replace every instance "string1" in a text field with "string2").
Or is there a super clever query that accomplishes this?
Thanks friends.
Duncan Hill escribió:
On Monday 12 June 2006 14:16, Gabriel Mahiques wrote:
but I have a problem with this solution, because I have the words in the
middle of the phrase.
For example: Movie Kill Bill Vol 1 in "vhs" format, and I want to
replace IT with Movie Kill Bill Vol 1
On Monday 12 June 2006 14:16, Gabriel Mahiques wrote:
> but I have a problem with this solution, because I have the words in the
> middle of the phrase.
> For example: Movie Kill Bill Vol 1 in "vhs" format, and I want to
> replace IT with Movie Kill Bill Vol 1 in "dvd" format.
> In Another case I
but I have a problem with this solution, because I have the words in the
middle of the phrase.
For example: Movie Kill Bill Vol 1 in "vhs" format, and I want to
replace IT with Movie Kill Bill Vol 1 in "dvd" format.
In Another case I have: "VHS" Trade Konami. . and I want to replace with
"DVD"
update table set field=REPLACE(field, 'vhs', 'dvd');
"Gabriel Mahiques" <[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED]
> Hello friends.
> In need your help.
> I have a table with a field "Name: Varchar(255)".
> In this field "Name" I have a detail and I need replace in all record
Hello friends.
In need your help.
I have a table with a field "Name: Varchar(255)".
In this field "Name" I have a detail and I need replace in all records a
word for another.
For example: I have "vhs" and I want to change the word "vhs" for the
word "dvd" in all records.
How can I do this?
--
S
in one directory into the column.
> 2 how do i do a search and replace the tags with the new correct ones ?
>
> Many thanks ...
>
>
> --=20
> Gregory Machin
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> www.linuxpro.co.za
> Web Hosting So
1 import all the pages in one directory into the column.
2 how do i do a search and replace the tags with the new correct ones ?
[/snip]
You don't use MySQL. But see http://www.mysql.com/replace
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubs
do I
1 import all the pages in one directory into the column.
2 how do i do a search and replace the tags with the new correct ones ?
Many thanks ...
--
Gregory Machin
[EMAIL PROTECTED]
[EMAIL PROTECTED]
www.linuxpro.co.za
Web Hosting Solutions
Scalable Linux Solutions
www.iberry.info (support
On 20-Jun-2003 Craig Harding wrote:
> 'url' has about 20 rows starting with 'disciplines/someurl' and I want
> to replace 'disciplines' with 'programs'. Is there a way to do this in
> mysql? I know I can do it in php, but it would be cool to do it, (and
> probably faster) to do it in mysql.
>
>
Try something like this:
UPDATE tablename SET url = concat("programs", substring(url,12)) where url
like ("disciplines/%");
Andy
> -Original Message-
> From: Craig Harding [mailto:[EMAIL PROTECTED]
> Sent: 20 June 2003 17:31
> To: [EMAIL PROTECTE
Is there is a way to do a search and replace on the mysql cmd prompt? I
want to replace text in about 20 rows that has the same pattern with a
replacement.
I have a table that has a column 'name' and a column 'url' which holds
menu items for a website. Both columns are type
Bay" while
leaving the number intact. Is there a way to do this
in MySQL? Some sort of search and replace command?
Thanks.
-bryan
=
--
Friday, January 11, 2002, 12:26:00 PM, you wrote:
> Hi there,
> I wonder if anyone can help?
> How would I go through a whole table changing the values:
> StuartD to stuartd
UPDATE users SET username = 'stuartd' WHERE username = 'StuartD';
--
Pål Sollie - [EMAIL PROTECTED]
Change is good m
Hi there,
I wonder if anyone can help?
How would I go through a whole table changing the values:
StuartD to stuartd
thanks a mil,
Stuart Otway.
MoveAssist International Ltd
Ickleford Manor
Turnpike Lane
Ickleford, Hitchin
Herts SG5 3XE
United Kingdo
Matt Davis ([EMAIL PROTECTED]) writes:
> I have an MySQL table in which one of the fields is a list of different
> catergorys. I want to change that catergory name to some thing else however
> it appears in my table just over 900 times. Is there any way I can do some
> sort of glaba
I have an MySQL table in which one of the fields is a list of different
catergorys. I want to change that catergory name to some thing else however
it appears in my table just over 900 times. Is there any way I can do some
sort of glabal search and replace in My SQL?
Mat
18 matches
Mail list logo
