MySQL Forums
Forum List  »  MySQL Workbench

passing variable in Where IN
Posted by: gujju desi
Date: March 28, 2013 02:44PM

How can I achieve this


set @namelist = "'nick','ED','grace',''dan'";
select * from actor where first_name IN (@namelist)



please help me out, thank you in advance

Options: ReplyQuote


Subject
Views
Written By
Posted
passing variable in Where IN
951
March 28, 2013 02:44PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.