Best way to search and replace text from blocks
Are you referring to custom blocks, not those provided by modules? If so, the main data is in the body column of the block_custom table in MySQL.

You could use an SQL query to perform the replacement.

UPDATE `block_custom` SET `body` = replace(body,"findstring","replacestring");




Credit: ChrisBrunner.com