title: passing an Array as a Parameter to be used in a SQL Query using the "IN" Command
body: <p>Good Afternoon to All,</p>
  
  <p>I have a question concerning on SQL Queries. is it possible to use an array as a parameter to a query using the "IN" command?</p>
  
  <p>for example,</p>
  
  <p>int x = {2,3,4,5}</p>
  
  <p>UPDATE 'table_name' set 'field' = data WHERE field_ID IN (x)</p>
  
  <p>the reason I am asking this is to avoid an iterative SQL Statement when I have to update data in a database. 
  I also thought of using a for each statement in for the UPDATE Query but I don't know if it will affect the performance of the query if it will slow down the system if ever 100+ records are updated.</p>
  
  <p>I am using VB.Net btw.
  My Database is MySQL Workbench.</p>