MySQL 8.4 Release Notes
12.8.2 COLLATE 子句优先级
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)