title: SQL: get a substring by removing character off the right and left
body: <p>I have a column of values like: </p>
  
  <pre><code> [{"run_status":1,"daily_budget":"2000","campaign_id":"60952315"}].
  </code></pre>
  
  <p>What is the query for removing the first and last bracket, so I am left with </p>
  
  <pre><code> {"run_status":1,"daily_budget":"2000","campaign_id":"60952315"}    
  </code></pre>
  
  <p>If your answer is dependent on SQL version, I am using Hive. </p>