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.
Use TEXT or BLOB columns' types. See:
http://dev.mysql.com/doc/mysql/en/blob.html
Use hexademical values in your scripts which load pages
in the database. See:
http://dev.mysql.com/doc/mysql/en/hexadecimal-values.html
Possibly you'll need to increase packet size. See:
h
[snip]
Please could you advise me my MySql, is a bit shacky.
I need to capture about 700 web pages to a large text column in my
database, the search for all the links in the pages within the column
and replace them with new relative links .. to the pages now stored in
the data base ..
so how do I
Hi all...
Please could you advise me my MySql, is a bit shacky.
I need to capture about 700 web pages to a large text column in my
database, the search for all the links in the pages within the column
and replace them with new relative links .. to the pages now stored in
the data base ..
so how do
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 PROTECTED]
> Subject: search and replace.
>
>
> I
Hello all,
I am trying to change part of a field across several
hundred rows, and am having difficulties. Here's the
setup: I have rows with field values of
"Rodregues0001" through "Rodregues0214". What I wish
to do is change the "Rodregues" to "TampaBay" while
leaving the number intact. Is ther
10 matches
Mail list logo
