Mysql replace question

Hi ,

I have this one stumping me but probably a simple one...

I have a field in a WordPress DB thats in the following format ;

this is an example

I need to change all of them to

this-is-an-example

I thought i could use :

UPDATE `wp_posts` SET `post_name` = replace(`post_name`, '''', '-'); 

Code (markup):

But no Joy..

Any ideas??

 

Anyone out there?

 

You were close

UPDATE `wp_posts` SET `post_name` = replace(`post_name`, ' ', '-');

Code (markup):

 

Excellent , thanks!
I couldnt be bold and ask if I could use the same to remove commas and questions marks in the same ? suppose i could..

Rep on its way :0)

 

Sorry it wont let me leave you an itrader, sorry !

 

No problem.. you can leave an iTrader only in the "Buy, Sell or Trade" section.