Questions tagged as 'dql'

I have a table with DDD and Phone fields. Some have been registered correctly, others ddd is next to the phone and I need to separate. TABLE +--------------------+ | DDD | Telefone | +--------------------+ | 47 | 89876543...

I need to look up all the "id_category" fields in a particular database, and bring up a list of tables that contain this field in common, which in this case is the foreign key of the "sis_category" table.     

I'm creating a method that gets values for createQueryBuilder () coming by parameters. I tested it in my local database with pdo_mysql driver and it worked perfectly, by ordering both an int (id) field and a varchar (title) type field. Howe...