title: How to search strings inside Array of arrays using eloquent
body: <p>So I have a databse column where the content is an Array like this:</p>
  
  <pre><code>[{"tag_name":"example1"},{"tag_name":"example2"}, {"tag_name":"example3"}]
  </code></pre>
  
  <p>What I am trying to do is to retrieve videos with a certain tag. All the videopages have specific tags, and when a user clicks one of those tags, it is redirected to a view where similar videos with the same tag will be displayed.</p>
  
  <p>Right now I have the following controller:</p>
  
  <pre><code>public function search($tag){
      $tag = urldecode($tag);
      $videos = Video::where('tags', 'LIKE', $tag)-&gt;paginate(12);
      $settings = Detail::find(1);
      $ads = Ad::find(1);
  
      return view('search', ['videos' =&gt; $videos, 'settings' =&gt; $settings, 'ads' =&gt; $ads]);
  
  }
  </code></pre>
  
  <p>And I have the following view (search.blade.php):</p>
  
  <pre><code>@foreach($videos as $video)
  
      &lt;div class="col-lg-4 col-xs-12"&gt;
  
          &lt;div class="row justify-content-center"&gt;
  
              &lt;a href="{{ route('videos.videopage', $video-&gt;id) }}"&gt;&lt;img class="articleImg" src="{{$video-&gt;imgurl}}"&gt;&lt;/a&gt;
  
          &lt;/div&gt;
  
  
          &lt;div&gt;
              &lt;p class="float-left"&gt;{{$title = substr($video-&gt;title, 0, 30) . " ..."}}&lt;/p&gt;
  
              &lt;small class="duration float-right"&gt;{{$video-&gt;duration}}&lt;/small&gt;
  
              &lt;div class="progress float-right"&gt;
                  &lt;div class="progress-bar bg-success" role="progressbar" style="width: {{$video-&gt;rating}}%" aria-valuenow="{{$video-&gt;rating}}" aria-valuemin="0" aria-valuemax="100"&gt;&lt;/div&gt;
              &lt;/div&gt;
  
  
          &lt;/div&gt;
  
      &lt;/div&gt;  
  
  
  @endforeach
  </code></pre>
  
  <p>The problem is that right now, no videos are shown in my view, even tough i get no errors at all. Is it because the columns has an array of arrays?</p>