title: MySQL stored procedure that accepts string with multiple parameters
body: <p>I want to create a stored procedure which accepts all the values in the IN parameter as a single string. </p>
  
  <pre><code>DELETE FROM object 
  WHERE Type NOT IN 
      ('ListGrid',
       'TextField',
       'SpinBox',
       'MenuButton',
       'ListGrid',
       'RadioButton',
       'DropDown',
       'PopUp',
       'Element',
       'Checkbox',
       'TreeDropDown',
       'TblColumn',
       'Button',
       'Link',
       'Filter',
       'TblRow',
       'GridRow',
       'Popup')
  </code></pre>
  
  <p>This is an example of one I've tried but it does not work.</p>
  
  <pre><code>DELIMITER //
  CREATE PROCEDURE deleteObjectTypes(IN p_type VARCHAR(255))
  BEGIN
  SET @query = CONCAT ('DELETE FROM object WHERE Type NOT IN (',p_type,')');
  PREPARE stmt FROM @query;
  EXECUTE stmt;
  DEALLOCATE PREPARE stmt;
  END //
  DELIMITER ;
  </code></pre>
  
  <p>I get the following error:</p>
  
  <pre><code>#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''List)' at line 1
  </code></pre>
  
  <p>When running this query:</p>
  
  <pre><code>CALL deleteObjectTypes("'ListGrid1','TextField1','SpinBox1','MenuButton1','ListGrid2','TextField2','SpinBox2','MenuButton2','ListGrid3','TextField3','SpinBox3','MenuButton3','ListGrid4','TextField4','SpinBox4','MenuButton4','ListGrid5','TextField5','SpinBox5','MenuButton5','ListGrid6','TextField6','SpinBox6','MenuButton6'")
  </code></pre>