How to select randomly with doctrine

by

The Doctrine team is not willing to implement this feature.

There are several solutions to your problem, each having its own drawbacks:

  • Add a custom numeric function: see this DQL RAND() function
    (might be slow if you have lots of matching rows)
  • Use a native query
    (I personally try to avoid this solution, which I found hard to maintain)
  • Issue a raw SQL query first to get some IDs randomly, then use the DQL WHERE x.id IN(?) to load the associated objects, by passing the array of IDs as a parameter.
    This solution involves two separate queries, but might give better performance than the first solution (other raw SQL techniques than ORDER BY RAND() exist, I won’t detail them here, you’ll find some good resources on this website).

More Related Contents:

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

Leave a Comment