title: Select, where JSON Array contains
body: <p>So in Laravel 5 there's the handy thing called <em>JSON Where Clauses</em> using MySQL's new ability to store and fetch JSON stored in a column:</p>
  
  <pre><code>User::where('meta-&gt;colors', 'red')-&gt;get()
  </code></pre>
  
  <p>would return all rows, where <code>colors</code> in the column <code>meta</code> would be set to <code>red</code>.</p>
  
  <p>Now let's say <code>colors</code> is not a string, but an array containing multiple colors (<code>colors =&gt; ['red', 'blue', 'green']</code>).  </p>
  
  <p>What would be an efficient way to retrieve all rows, where <code>colors</code> contains e.g. the value <code>red</code>?</p>