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