Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 37 down vote favorite
7

So I am trying to accomplish something like this:

SELECT * FROM table WHERE status_id IN (1,3,4);

using Zend_Db_Select... can't find how to do it :( Is it at all possible?

share|improve this question

3 Answers

up vote 77 down vote accepted

you can also use it like this:

$data = array(1,3,4);
$select->where('status_id IN(?)', $data);

you dont need to implode array, and it's safer

share|improve this answer
4  
Googled this problem and found your solution - then realized I had already upvoted it once. So since I can't upvote you again, take this comment as my token of appreciation! – leek Apr 15 '10 at 2:07
great, many thanks :) – Martin Rázus Apr 29 '10 at 11:20
So many variations on paramaterizing INs, thanks for saving my an evening of using google glopping! – Alan Storm Oct 15 '10 at 0:28
Martin, I'd tried with implode, but saw that the whole string was quoted. thanks for providing a simple solution. Works like a charm! – Matt Setter Sep 11 '11 at 8:27
up vote 6 down vote

apparently it is super simple... stupid me:

$select->where('status_id IN(1,3,4)');

:(

share|improve this answer
Yes, that's right. – Bill Karwin Dec 4 '08 at 6:32
up vote 1 down vote 
$completionNo = implode(",",$data);

$db = Zend_Db_Table_Abstract::getDefaultAdapter();
$select = $db->select()->from(array("p"=>PREFIX . "property_master"),array('id','completion_no','total_carpet_area'))->where("p.completion_no IN (?)", $completionNo);
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.