How to replace some text in a MySQL table

Replacing text in a MySQL table is easy if you have a client like phpmyadmin to run SQL commands.

update wp_downloads set file = replace(file, 'download/', 'downloads/');