Redux

Hi to all, I know this is not the proper category to post my problem since it is mysql related.. I have a name field in my database (eg. John Smith L.) what i want to happen is to split this into three fields (fname,lname mname) mname stands for middle name.. Help me please. Thanks in advance!