I have a view that I need to extend with a value from the select;

```
select 
`mc_cf7dbplugin_submits`.`submit_time` AS `submit_time`,
`mc_cf7dbplugin_submits`.`form_name` AS `form_name`,
`mc_cf7dbplugin_submits`.`field_name` AS `field_name`,
`mc_cf7dbplugin_submits`.`field_value` AS `field_value`,
`mc_cf7dbplugin_submits`.`field_order` AS `field_order`,
`mc_cf7dbplugin_submits`.`file` AS `file`,`mc_cf7dbplugin_submits`.`processed` AS `processed` 
from `mc_cf7dbplugin_submits` 
where isnull(`mc_cf7dbplugin_submits`.`processed`)

```

The variable I need to show called 'file\_name' should be the contents of 'field\_value' if the 'field\_name' is equal to 'File'

Is this possible and if so, how would I do this?