mysql - Combining multiple columns into one new column, while keeping the original column

Question

I have below table, where I am trying to merge the columns in yellow in one column, while maintaining the original columns; the data in the highlighted yellow columns is populated based on the interaction type they fall into if the interaction type is null that means it doesn't fall into the interaction type category:

Would appreciate any help or guidance on how I can approach this

Expected outcome:

Answer 1

This looks like coalesce():

select t.*,
    coalesce(
        svc_proc, 
        interest, 
        transtypekey, 
        connectivity_name, 
        vm_entreprise_program,
        channels
    ) as interaction_details
from mytable t

coalesce() returns the first non-null value of the arguments list.