How to select phone numbers (`Phone`) in which the sum of the first three digits is equal to the sum of the last three?

Question

MySQL

How to select phone numbers (`Phone`) in which the sum of the first three digits is equal to the sum of the last three? The number consists of 6 digits.

Answer 1

for example

SET @phone = '894585454786';
SELECT @phone, (SUBSTR(@phone, 1, 1) + SUBSTR(@phone, 2, 1) + SUBSTR(@phone, 3, 1)) - (SUBSTR(@phone, -3, 1) + SUBSTR(@phone, -2, 1) + SUBSTR(@phone, -1, 1))