sql 문으로 특정 문자열만 추출

select substring_index(substring_index(colum_name, 'front_unique_str', -1), 'rear_unique_str', 1) as name from table_name

->
select substring_index(substring_index(nationality, '(', -1), ')', 1) as name from nationality