In my select I create an alias. I use a like expr on this alias in the having clause.
Trying several variations I still get the following error:
Expected '.' or '(', got 'long_name'
My example including variations inside comments:
I use a Doctrine Extension for the MySQL GROUP_CONCAT functionality:
This should have no effect on the result since I tried a simple alias - see comment - instead of it.
The problem seems to be using an alias inside the having clause when adding the like expr.
The following clause would work:
I also tried this workaround using the GROUP_CONCAT method inside the where part:
Allthough I used the groupBy part I got this error:
General error: 1111 Invalid use of group function