Hi ,
I'm trying to perform a SQL query containing several calls to mySQL replace
functions.
On the same basis that this :
" SELECT replace(message, "@TITLE@", title) FROM ** "
in this case, message and title are 2 fiels of the the same table
I want to do something like this :
SELECT replace(message, "@TITLE@", title) FROM ** "
+ replace (message, "@SIGNATURE@", signature)
with message, title and signature 3 fiels of the db
I mean several string replace in the same SELECT statement!!!
I did try this :
SELECT replace(message, "@TITLE@", title),
replace(message, "@SIGNATURE@", signature) FROM ***
But it generates 2 different query results....
Any ideas of syntax for the right query!!!
__
Xavier Prélat
w e b c e n t r i c
________________________
25, rue de Ponthieu
75008 Paris
[EMAIL PROTECTED]
http://www.wcentric.com
________________________
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
