MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:March 17 1999 3:09pm
Subject:Re: Problem with REPLACE
View as plain text  
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 ...


Problem with REPLACEZderadicka Jan - IN17 Mar
  • Re: Problem with REPLACEChristian Mack17 Mar