# Change all aliases with paths like foo/* to bar/* 
UPDATE url_alias SET dst = REPLACE(dst, 'foo/', 'bar/') WHERE dst LIKE 'foo/%';


# Delete all aliases with paths like foo/*
DELETE FROM `url_alias` WHERE dst LIKE 'category/%';

In case you don't feel like loading 3 pages to edit a single url alias.

MySQL queries for bulk editing Drupal url aliases

drupal

MySQL