Mysql replace question

[sparksflying]

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`, '''', '-');

But no Joy..

Any ideas??

[sparksflying]

Anyone out there? ;)

[SoKickIt]

You were close :)

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

[sparksflying]

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)

[sparksflying]

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

[SoKickIt]

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.