From: Zderadicka Jan - IN
Date: March 17 1999 1:59pm
Subject: Problem with REPLACE
List-Archive: http://lists.mysql.com/mysql/425
Message-Id: <13249DE3821@st.vse.cz>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7BIT

 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