Jump to content

REPLACE() Multiple Argument?


triphp

Recommended Posts

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?

Link to comment
https://forums.phpfreaks.com/topic/2737-replace-multiple-argument/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.