通常,您会执行以下操作:
$q = Doctrine_Query::create()
->from('User u')
->whereIn('u.id', array(1, 2, 3));
但我认为这更适合您的需求:
$q = Doctrine_Query::create()
->from('Foo f')
->where('f.group_id IN (SELECT f.group_id FROM Alert a WHERE a.monitor_id = ?)', 4);
教义如何在其中使用另一个sql查询编写WhereIn()
通常,您会执行以下操作:
$q = Doctrine_Query::create()
->from('User u')
->whereIn('u.id', array(1, 2, 3));
但我认为这更适合您的需求:
$q = Doctrine_Query::create()
->from('Foo f')
->where('f.group_id IN (SELECT f.group_id FROM Alert a WHERE a.monitor_id = ?)', 4);