title: MySQL stored procedure passing array of number in parameters
body: <p>I'am not sure what I've been doing wrong ...</p>
  
  <p>I have a simple query :</p>
  
  <pre><code>SELECT * FROM locations WHERE (ID IN (1, 2, 3, 4, 5));
  </code></pre>
  
  <p>now I just took that query and made it into a store procedure with an arguments of type LONGTEXT</p>
  
  <pre><code>sp_FetchMultipleLocations(IN argLocations LONGTEXT)
  BEGIN
      SELECT * FROM locations WHERE (ID IN (argLocations));
  END;
  </code></pre>
  
  <p>then I call that stored procedures with multiples values in that parameters :</p>
  
  <pre><code>CALL sp_FetchMultipleLocations('1, 2, 3, 4, 5');
  </code></pre>
  
  <p>but the IN statement in the where clause doesn't seem to be working, it shows me only the first(1) location ... why is that ?</p>
  
  <p>thanks</p>