title: Stored procedure with select where in array
body: <p>I need <strong>Stored procedure</strong> for my select query.</p>
  
  <p>My problem is i have String array it's contain multiple mobile numbers to compare db table if available or not.if available return row values.</p>
  
  <p>I am using mysql 5.1.It's not supported for comparing array values in select query.</p>
  
  <p>I got error <strong>Mysql feature not supported exception</strong>.so i will change my code using String builder.
  I already asked.</p>
  
  <p>My question:[<a href="https://stackoverflow.com/questions/28411605/mysql-stored-procedure-with-java-string-array][1]">Mysql Stored procedure with java String Array</a></p>
  
  <p>So if any possible to compare array values using Store procedure.
  My select query is :</p>
  
  <pre><code>SELECT USER_ID, USER_NAME, REGISTRATION_ID, IMEI_CODE, MOBILE_NUMBER FROM USER WHERE MOBILE_NUMBER IN (String_array);
  </code></pre>
  
  <p>In this query return if</p>
  
  <p>`String_array = "one_string_values";</p>
  
  <p>It return single rows.[<strong>Using java jdbc queryforObject</strong>]</p>
  
  <p>If string_array = "array_of_values"`</p>
  
  <p>It return nothing i got exception <strong>Mysql feature not supported exception</strong></p>
  
  <p>Any possibilities available for using Stored procedure in my scenario. </p>