Voici les requêtes que j’utilise afin de retrouver dans la base de donnée de Drupal tous les liens du site Internet.

select * from block_custom where body like '%example.com%';
select * from field_data_body where body_value like '%example.com%';
select * from field_data_field_additional_information where field_additional_information_value like '%example.com%';
select * from field_data_field_body where field_body_value like '%example.com%';
select * from field_data_field_download_product_link where field_download_product_link_value like '%example.com%';
select * from field_data_field_text where field_text_value like '%example.com%';
select * from field_data_message_text where message_text_value like '%example.com%';
-- select * from field_revision_body where body_value like '%example.com%';
-- select * from field_revision_field_body where field_body_value like '%example.com%';
-- select * from field_revision_field_text where field_text_value like '%example.com%';
-- select * from field_revision_message_text where message_text_value like '%example.com%';
select * from menu_links where link_path like '%example.com%';
select * from redirect where redirect like '%example.com%';

Pas oublier de rajouter les tables des modules installé ou créé qui peuvent contenir des liens à devoir remplacer.

Tenir compte aussi des champs créé dans drupal de vos content type qui contiennent des liens comme par exmemple dans mon cas la table field_data_field_download_product_link qui contient un lien de description du produit