title: Laravel json join , Trying to Join JSON column having multiple ids with table of locations having location ids, query builder
body: <p>I trying to join to two tables one with locations and another archive_data that can have multiple locations. so I am storing locations in archive data as <strong>json</strong> like this <strong>["1","2","3"]</strong></p>
  
  <p>My query: </p>
  
  <pre><code>                    DB::table('archive_data as a')
                      -&gt;join('person as pe', 'pe.pe_id', '=', 'a.a_pe_id')
                      -&gt;join('portfolio as p', 'p.p_id', '=', 'a.a_p_id')
                      -&gt;join('tag as ta', 'ta.ta_id', '=', 'a.a_ta_id')
                      -&gt;join('type as t', 't.t_id', '=', 'a.a_ty_id')
                      -&gt;join('location as l', 'l.l_id', '=',"a.a_lc_id")
                      -&gt;join('series as s', 's.s_id', '=', 'a.a_s_id')
                      -&gt;join('bundle as b', 'b.b_id', '=', 'a.a_b_id');
  </code></pre>
  
  <p>Please tell me how can I join these two tables using laravel query builder. Thank you in advance. </p>