title: iterating over arrays in MYSQL
body: <p>Is there a way to pass an array into a MySQL query and return the results as another array ?(apart from using cursors which would be an overkill for my use case)</p>
  
  <p>For a single id, my query looks like this. </p>
  
  <pre><code>SET @userId = '04b452cd59dcc656'
  Select user_account_number from userstore where u_id = @userId ;
  </code></pre>
  
  <p>Instead of sending each id at a time, I am trying to send a list and return a list </p>
  
  <pre><code>SET @userId = ('04b452cd59dcc656','eqwe52cddasfsd656');
  &lt;query returning the list of account numbers&gt;
  </code></pre>
  
  <p>Also - I think this would be efficient over just sending one id at a time. Thoughts ?</p>