change all _ to - in url

hi
how can i change all "_" to "-" symbol in all of canonical urls?
is there any way through mass actions?

Hi,

Yes, with the action "update the values" on the column "product_canonical" with the type "operation" and the value: REPLACE(product.product_canonical, '_','-')

thanks, is there a way doing this action for "category" urls?

Hi,

Sure. Just use the "category" data in your mass action, and select the "category_canonical" column in the "update the values" action and use instead the value:
REPLACE(category.category_canonical, '_','-')