Lab Sql

I generate an SQL from NativeQuery and this is the result sql: SELECT COUNT(id) AS tot,created_at … Read more Doctrine 2.0 Nativequery Resultsetmapping For Count(id)

I`m looking for a way to create a doctrine query with ignoring spaces. I try with replace but I rec… Read more Doctrine Query - Ignoring Spaces

I have problems to create a Doctrine Query with LIKE Expression: QUERY: $dql = 'SELECT u FRO… Read more Doctrine Query + Like Expression

Having issues with Doctrine 2.3 and PostgreSQL with Spaces and Upper case Field / Table names Examp… Read more Doctrine - Postgresql - Uppercase And Spaces In Table / Field Names

Just started using doctrine. question. I have a lookup table that does 2 joins. How can I do this i… Read more Doctrine Join Multiple Tables

I have a lot of difficulties in trying to translate this SQL query to a DQL one (I am using Symfony… Read more How To Translate This Sql Query To Dql?

I am trying to get the latest booked courses (unique). I have tried the following with the Doctrine… Read more Symfony Doctrine Orderby And Group By (distinct)

Little example about Books and Authors: DB structure: Entities (they were generated form database … Read more Doctrine Many-to-many Relations And Onflush Event