I want to create a Doctrine Query: (Doctrine 2.3) SELECT * FROM `car` WHERE `plate` like '%' AND (`datetime` BETWEEN '2013-03-13 22:20:18' AND '2013-03-13 22:20:20') OR (`datetime` BETWEEN '2013-0...

I am trying to do a simple query in doctrine but struggling. $query->select(array( 'app_title' => 'u.title', 'user_name' => 'u.user_name', 'first_used' => 'MIN(u.creation_time)', ...

I have an entity A with a relation ManyToOne with B but A and B doesn't belong to the same DB schema. Entity 'A' belongs to MyBundle bundle, and entity 'B' belongs to MyOtherBundle bundle. The of...

I would like to do an update-query with a LIMIT like that: UPDATE anytable SET anycolumn = 'anyvalue' WHERE anothercolumn='anothervalue' LIMIT 20 How is this possible with doctrine 2.1 ?

I'm having problems using find*() magic methods of Doctrine2 when the field has an underscore in between. $repository->findByName("Hello"); // Works $repository->findByIsEnabled(true); E...

I'm having trouble executing a Doctrine DQL Query. This is the error it gives me. Doctrine\Common\Annotations\AnnotationException: [Syntax Error] Expected PlainValue, got 'integer' at position 13...