MySQL Forums
Forum List  »  Newbie

Re: In Subquery with Comma Separated String
Posted by: Jay Alverson
Date: March 25, 2009 08:42AM

and productid in (variable-string) << so 20 and 7 missing

You want mySQL to treat it like:

and productid in ("38,20,7") ???

If that's what you're shooting for, you'll need to use a PREPARED statement.

Otherwise provide us with some sample data, and some sort of simple example,
unless you feel like going hog-wild.

>

Thanks, Jay

Options: ReplyQuote


Subject
Written By
Posted
Re: In Subquery with Comma Separated String
March 25, 2009 08:42AM


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.