MySQL 8.0 Reference Manual
MySQL 8.0 Release Notes
The COLLATE clause has high precedence
(higher than ||), so
the following two expressions are equivalent:
x || y COLLATE z
x || (y COLLATE z)
The COLLATE clause has high precedence
(higher than ||), so
the following two expressions are equivalent:
x || y COLLATE z
x || (y COLLATE z)