SELECT
    SUBSTR(3987654321, (@cnt := @cnt + 1), 1) AS SplitDigits
-- from any table has rows greater than or equal to 10
FROM (SELECT NULL FROM INFORMATION_SCHEMA.TABLES LIMIT 10) A
CROSS JOIN (SELECT @cnt := 0) B
;