How to Split single column value in to multiple using mysql

Question

string str2 = "select pm.paxseqno,pm.guestallowed,pm.paxname,pm.cardtype,pm.class,pm.paxseatno,pm.status,pm.ffpno,pm.Time,CASE WHEN cf.Cabin = 'F' THEN'First Class'WHEN cf.Cabin = 'E' THEN 'Economy' WHEN cf.Cabin = 'P' THEN 'Premiere'WHEN cf.Cabin = 'K' THEN 'Unknown'ELSE 'Unknown' END as Cabin from paxmaster Pm left join cabininfo cf on Pm.class=cf.class

 

pm.paxname contails Full Name Like 'DALAL MIHIRMR'  this

 

and i want to split name in to two column Like First Name is' MIHIRMR'  and Second Clolumn is 'DALAL' in My Sql

 

 

So How to do this

 

Please Help