title: How to Pass a List of String in MySQL Stored Procedure?
body: <p>I'm trying to pass an array as a String in MySQL Stored Procedure but it doesn't work fine.</p>
  
  <p>Here's my SQL Codes:</p>
  
  <pre><code>CREATE DEFINER=`root`@`localhost` PROCEDURE `search_equipment`(IN equip VARCHAR(100), IN category VARCHAR(255))
  BEGIN
      SELECT *
          FROM Equipment
          WHERE e_description
          LIKE CONCAT("%",equip,"%")
              AND e_type IN (category)
  END
  </code></pre>
  
  <p>And here's how i call the procedure:</p>
  
  <pre><code>String type = "'I.T. Equipment','Office Supply'";
  
  CALL search_equipment('some equipment', type);
  </code></pre>
  
  <p>Any ideas?</p>