title: WHERE IN give me different results when ran in PhpMyAdmin
body: <p>When I run the following query in phpMyAdmin</p>
  
  <pre><code>    SELECT 
          locations.name,
          locations.id,
          locations.lon,
          locations.lat,
          locations_categories.category_id as catId,
          locations_categories.location_id as locId,
          haversine(40,90,locations.lon,locations.lat) as distance
      FROM locations_categories, locations  
      WHERE locations.id = locations_categories.location_id
      AND locations_categories.category_id IN ("9","1","7")  
      ORDER BY `distance` ASC
  </code></pre>
  
  <p>It gives me the following results, which are correct.</p>
  
  <p><a href="https://i.stack.imgur.com/p3OeY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/p3OeY.png" alt="enter image description here"></a></p>
  
  <p>But When I run the following in my Laravel Application it only returns the locations with catId of 9.</p>
  
  <pre><code>        // dump($request-&gt;categories);
          $categories = implode('","',$request-&gt;categories);
  
          //dd($categories);
  
  
          $statement = &lt;&lt;&lt;'ENDSTATEMENT'
          SELECT 
              locations.name,
              locations.id,
              locations.lon,
              locations.lat,
              locations_categories.category_id as catId,
              locations_categories.location_id as locId,
              haversine(?,?,locations.lon,locations.lat) as distance
          FROM locations_categories, locations  
          WHERE locations.id = locations_categories.location_id
          AND locations_categories.category_id IN (?)  
          ORDER BY `distance` ASC
  ENDSTATEMENT;
  
      $locations = DB::select($statement, array($request-&gt;lon, $request-&gt;lat, $categories));
  </code></pre>
  
  <p>The results of the </p>
  
  <pre><code>dd($categories);
  </code></pre>
  
  <p>is the following screenshot</p>
  
  <p><a href="https://i.stack.imgur.com/En1Rt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/En1Rt.png" alt="enter image description here"></a></p>
  
  <p>My question is, Why does this work and return all the values needed in PhpMyAdmin but not when ran within the application??</p>