Thread: Re: parsing parameter list to Stored Procedure

To support lists, you could use a temporary table instead of a procedure parameter: CREATE TEMPORARY TABLE list_table( country VARCHAR(255) ); INSERT INTO test.ttt VALUES ('MY'),('ID'),('TW'); Then, just rewrite your SELECT: select * from user_list where country IN (SELECT country FROM list_table); Devart Company, Database development tools http://www.devart.com...

Tupa, A simple way to do that is with PREPARE: [code] DROP PROCEDURE IF EXISTS spMySampleStoredProc; DELIMITER go CREATE PROCEDURE spMySampleStoredProc( list varchar(1000) ) BEGIN SET @sql=concat( 'select * from user_list where country in(', list, ')' ); PREPARE stmt FROM @sql; EXECUTE @sql; DROP PREPARE stmt; END; go DELIMITER ; PB http://www....

thanks Peter, it works.. but there is a correction: not EXECUTE @sql; but EXECUTE stmt; but Overall good. thanks.

Yep, thx, corrected.