How to use WHERE IN with Doctrine 2

by

The easiest way to do that is by binding the array itself as a parameter:

$queryBuilder->andWhere('r.winner IN (:ids)')
             ->setParameter('ids', $ids);

More Related Contents:

  1. Select entries between dates in doctrine 2
  2. Subquery in doctrine2 notIN Function
  3. Join subquery with doctrine 2 DBAL
  4. Doctrine2: Best way to handle many-to-many with extra columns in reference table
  5. Is there a built-in way to get all of the changed/updated fields in a Doctrine 2 entity
  6. On delete cascade with doctrine2
  7. Why I am suddenly getting a “Typed property must not be accessed before initialization” error when introducing properties type hints?
  8. How to do left join in Doctrine?
  9. Default value in Doctrine
  10. Doctrine 2 and Many-to-many link table with an extra field
  11. How to select randomly with doctrine
  12. Should I use EAV model?
  13. Too much data with var_dump in symfony2 doctrine2
  14. How to re-save the entity as another row in Doctrine 2
  15. Cakephp-3.x: How to change the data type of a selected alias?
  16. Injecting SecurityContext into a Listener prePersist or preUpdate in Symfony2 to get User in a createdBy or updatedBy Causes Circular Reference Error
  17. How to set up entity (doctrine) for database view in Symfony 2
  18. Symfony2, Dynamic DB Connection/Early override of Doctrine Service
  19. How to get a one-dimensional scalar array as a doctrine dql query result?
  20. How to setup table prefix in symfony2
  21. How to use a findBy method with comparative criteria
  22. Symfony 2.0 getting service inside entity
  23. “Class XXX is not a valid entity or mapped super class” after moving the class in the filesystem
  24. Can I access discriminator field from php in doctrine2?
  25. How to force Doctrine to update array type fields?
  26. Query on a many-to-many relationship using Doctrine with Symfony2
  27. Doctrine2 association mapping with conditions
  28. How can I use DATE() in Doctrine 2 DQL?
  29. Transposing multidimensional arrays in PHP
  30. How do you reindex an array in PHP but with indexes starting from 1?

Leave a Comment