Jump to content


REPLACE() Multiple Argument?

  • Please log in to reply
No replies to this topic

#1 triphp

  • Members
  • Pip
  • Newbie
  • 7 posts
  • LocationCebu, Philippines

Posted 26 October 2005 - 08:24 AM

How can I have a query to replace multiple strings. For example:

string = "the { quick brown " fox [ jump \/ ! £ $ %^&*«over»,.;:'#@~{ the lazy dog}|=+`<period>?]+"

I want that al those special characters found ("[\/!£$%^&*«»,.;:'#@~{}|=+`<>?]+" ) on that string will be replace by dashed(-).
What I have now is just only the space replace with dashed(-).:

SELECT REPLACE(string, ' ', '-') as turl FROM table;
I don't know how to put another argument in the from_str of REPLACE () function

Please take note that I can't use PHP ereg_replace. I have to badly do this in MySQL only. Is this possible?
http://www.spokendollars.com/- Let's talk how to earn money online.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users