I would like to know if it's possible to alias a column name with spaces in for example
$query = "SELECT u.firstName AS 'First Name' FROM User u";
$result = $query->getResult( Query::HYDRATE_ARRAY );
Asked
Active
Viewed 1,063 times
6
Korush Mahdavieh
- 541
- 5
- 15
-
I don't think this is possible using doctrine DQL, your chance perhaps is to get a PDO instance and write a native SQL query which must support what you want. – Ibrahim Azhar Armar Jan 07 '17 at 09:30
-
I have managed to get this working using native query and using the result mapping class, but obviously doesn't use my soft delete filter for example, so hence why having to use dql – Korush Mahdavieh Jan 07 '17 at 09:43
-
Have you tried using back ticks \`First Name\`? Doubt if it will work but maybe. – Cerad Jan 07 '17 at 13:22
-
Yes I've tried that already – Korush Mahdavieh Jan 07 '17 at 14:37