How to update path alias using MySQL command line Many words have been renamed in the node using the below code:



update node set title = replace(title,'Apple','Orange')
update node_revisions set title = replace(title,'Apple','Orange');


But now I need to know how to update the path aliases using the MySQL command line; using the Drupal administration interface is very tiring, for thousands nodes.
I don't think you will have much success using mysql, the quickest way is likely to write a script that bootstraps drupal, loads each node and then saves the node, I think this should update the aliases.