Variables in stored procedure

[Adam Gerson]

I am getting the error that "TABLENAME" does not exist. How do I get it 
to substitute the value stored in TABLENAME, and not the literal string?

begin

declare v_max int unsigned default 1;
declare v_counter int unsigned default 21;
declare TABLENAME text;

   start transaction;
   while v_counter <= v_max do
	SET TABLENAME = CONCAT('wp_',v_counter, '_options');
	INSERT INTO TABLENAME VALUES ('309', '0', 'statpress_mincap', 
'edit_posts', 'yes');
     set v_counter=v_counter+1;
   end while;
   commit;
END


Thanks,
Adam

-- 
Adam Gerson
Co-Director of Technology
Columbia Grammar and Prep School
phone. [phone] ex. 321
fax.  [phone]
agerson@stripped
http://www.cgps.org