Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
User Defined Variable used within IN of WHERE clause?
Prepared statements work fine in general. Having a bit 'o difficulty with the syntax for using a variable in the IN portion of a WHERE clause. Works great with a single value, but not more than one.. i.e. SET @list = "2"; PREPARE my_stmt FROM 'SELECT * FROM <table> WHERE my_id in (?)' EXECUTE...
