mysql 字符串转十进制后取余

select (cast(conv(substr(MD5(name1), 1, 16), 16, 10) as decimal(65))*18446744073709551616
+ cast(conv(substr(MD5(name1), 17, 16), 16, 10) as decimal(65)))%10 AS DecimalValue
 from sgk_qqpass_old where name1 like "8789%" GROUP BY DecimalValue limit 10