title: Querying Postgres SQL JSON Column
body: <p>I have a json column (json_col) in a postgres database with the following structure: </p>
  
  <pre><code>{
     "event1":{
        "START_DATE":"6/18/2011",
        "END_DATE":"7/23/2011",
        "event_type":"active with prior experience"
     },
     "event2":{
        "START_DATE":"8/20/11",
        "END_DATE":"2/11/2012",
        "event_type":"active"
     }
  }
  </code></pre>
  
  <p>[example of table structure][1]</p>
  
  <p>How can I make a select statement in postgres to return the start_date and end_date with a where statement where "event_type" like "active"? </p>
  
  <p>Attempted Query: </p>
  
  <pre><code>select person_id, json_col#&gt;&gt;'START_DATE' as event_start, json_col#&gt;&gt;'END_DATE' as event_end
  from data
  where json_col-&gt;&gt;'event_type' like '%active%'; 
  </code></pre>
  
  <p>Returns empty columns. </p>
  
  <p>Expected Response: </p>
  
  <pre><code>event_start  
  6/18/2011
  8/20/2011
  </code></pre>