How to Split single column value in to multiple using mysql

Please try below query,

 

string str2 = "select pm.paxseqno,pm.guestallowed,left(pm.paxname, CHARINDEX(' ', pm.paxname)) as firstName,substring(pm.paxname, CHARINDEX(' ', pm.paxname)+1, len(pm.paxname)-(CHARINDEX(' ', pm.paxname)-1)) as lastName,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 

SELECT

SUBSTRING_INDEX(trim(title),' ',-1) last_name,

SUBSTRING_INDEX(trim(title),' ',1) first_name

from Test

 

 

try with 

SUBSTRING_INDEX(POS, ',', 1) for position1

SUBSTRING_INDEX(POS, ',', -1) for position2

 

getting error in my code-

 

 

try this 

 

select left(name, CHARINDEX(' ', name)) as firstname, substring(name, CHARINDEX(' ', name)+1, len(name)-(CHARINDEX(' ', name)-1)) as lastname from users  
If it helps mark as accepted answer so other user can refer.