MySQL 9.0 Reference Manual Including MySQL NDB Cluster 9.0
The COLLATE clause has high precedence (higher than ||), so the following two expressions are equivalent:
COLLATE
||
x || y COLLATE z x || (y COLLATE z)