SQL: get a substring by removing character off the right and left
===

I have a column of values like: [{"run_status":1,"daily_budget":"2000","campaign_id":"60952315"}].

What is the query for removing the first and last bracket, so I am left with {"run_status":1,"daily_budget":"2000","campaign_id":"60952315"}? 

If your answer is dependent on SQL version, I am using Hive. 