title: Laravel sql search json type column
body: <p>The mysql has table 'subscribe' table and it's as follows:</p>
  
  <pre><code>column   type
  id        int
  condition  json
  type_id    id
  </code></pre>
  
  <p>and the example as follows:</p>
  
  <pre><code>"id": "1",
  "condition": "{\"id\":\"2\",\"class\":\"master\",\"zone\":\"west\",\"price\":\"511\"}",
  "type_id": "1"
  </code></pre>
  
  <p>and I want to select the column which match in the column condition like "zone"="west"
  the laravel 5.2 has support the order</p>
  
  <pre><code> $subscribe = DB::table('subscribe')-&gt;where('condition-&gt;class', 'master')-&gt;get();
  </code></pre>
  
  <p>Error </p>
  
  <pre><code> Column not found: 1054 Unknown column 'condition-&gt;class' in 'where clause'(
  SQL: select * from `subscribe` where `condition-&gt;class` = master)
  </code></pre>
  
  <p>I need is get the term which match the condition where conditon->class = master .I need to select the data which match the need in the model.
  I don't know what's wrong. Any help would be much appreciated.</p>