Zderadicka Jan - IN wrote:
>
> Hi !
>
> I have a problem when trying to make a SELECT with REPLACE.
>
> I have a text with email addresses and I would like to make them
> active. It means to rewrite them to HTML language.
>
> Consider text: "Hello, my address is go@stripped and you can use it".
> ==== >
> which I would like to change to:
>
> "Hello, my address is <A HREF="mailto: go@stripped">go@stripped</A>"
>
> I decided to use the syntax:
>
> SELECT REPLACE($text, $mail, $newmail) where $text is the variable
> which includes the plain text and email addresses, $mail is the
> concrete mail I am searching (e.g. go@stripped) and $newmail stands
> for email writen in HTML language. (<A HREF... etc.).
>
> Unfortunately this syntax does not work. But probably not because of
> the syntax itself, but because Mysql can't replace the previous email
> with HTML language. The problem is with "<" and ">" characters.
>
> ==========
> Do you know, how to replace any text with the combination of "<>"
> characters ? These characters are not consider as special I think and
> that's why I think quoting with "\" is not needed.
>
> I am using PHP to get to Mysql database.
>
> John Zderadicka
> Prague
Hi John
A SELECT statement _never_ changes the contents of tables.
Therefore you have to use UPDATE like that:
UPDATE tablename SET $text=REPLACE($text, $mail, $newmail) WHERE ...
Tschau
Christian

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.