select 'VbVlinks' table_name, 'link_rss' column_name,
        convert(`link_rss` using utf8) collate utf8_unicode_ci column_value, 'link_id' pk_column_name,
        convert(`link_id` using utf8) collate utf8_unicode_ci pk_column_value, 1 pk_column_count
from
        `VbVlinks`
where
        (`link_rss` like '%https://test.example.com%'
or   `link_rss` like '%https:\\/\\/test.example.com%' escape '|'
or   `link_rss` like '%https%3A%2F%2Ftest.example.com%' escape '|') ;

select 'VbVlinks' table_name, 'link_visible' column_name,
        convert(`link_visible` using utf8) collate utf8_unicode_ci column_value, 'link_id' pk_column_name,
        convert(`link_id` using utf8) collate utf8_unicode_ci pk_column_value, 1 pk_column_count

from
        `VbVlinks`
where
        (`link_visible` like '%https://test.example.com%'
or   `link_visible` like '%https:\\/\\/test.example.com%' escape '|'
or   `link_visible` like '%https%3A%2F%2Ftest.example.com%' escape '|')

union all 
select 'VbVmec_attendees' table_name, 'data' column_name,
        convert(`data` using utf8) collate utf8_unicode_ci column_value, 'attendee_id' pk_column_name,
        convert(`attendee_id` using utf8) collate utf8_unicode_ci pk_column_value, 1 pk_column_count

from
        `VbVmec_attendees`
where
        (`data` like '%https://test.example.com%'
or   `data` like '%https:\\/\\/test.example.com%' escape '|'
or   `data` like '%https%3A%2F%2Ftest.example.com%' escape '|');
