How to get the first letter of a string field using DQL ?

Question

Doctrine ORM

How to get the first letter of a string field using DQL ? I tried using the LEFT([field],1) function, but it gives an error.

Answer 1

Assumptions:
- the doctrine does not understand such a function. You can solve the problem like this
- if you call getResult on the received query, then in any case you will get an error, because the doctrine does not know which field to map the result to. To do this, you need to change
to
and call not getResult, but getArrayResult, for example.