How to Split the String in Mysql?

How can I split the string like this:

John23Robert435Kim2

to table like this:

===================
John     |  23
Robert   |  435
Kim      |  2
===================