Permalink %postname% uses underscore – want hyphens

edit the post slug and change the _ to a – ?

But I have to do that indiviually on every post don’t I? I have hundreds of posts I migrated from Drupal to WP and that will take forever. I’m looking for a way to do them all at once.

Edit the database directly then, and modify the postname’s in there.

update wp_posts set post_name = replace(post_name,'_','-');

Cool. Thanks. That I can do.

Thanks Otto! I needed this too! ??

Edit the database directly then, and modify the postname’s in there.

update wp_posts set post_name = replace(post_name,’_’,’-‘);

Which database should be edited, may I ask for details please?

Oh I see, it was meant to change the database entries, I guess…