rafaelrgl
asked on
Formating field inside mysql query
Hi, I have one field called seller, and inside I have those kind of values
JAMROZ,STOMP F & MARIA N
JOHN,FORD F
MARY, STEMP
PAUL, FORD & MARY N
So as you can see I have first name, last name ( maybe middle name), than i have & if there is another person, and aftert that First Name second person and Middle name last person. I need a way to extract those inside my query so i have something like this
select (conditions to get this) as Seller1First, (conditions to get this) as Seller1Middle, (conditions to get this) as Seller1Last, (conditions to get this) as Seller2First, Seller2Last from .......
This is MYSQL, but I added the sql topics too since is related.
JAMROZ,STOMP F & MARIA N
JOHN,FORD F
MARY, STEMP
PAUL, FORD & MARY N
So as you can see I have first name, last name ( maybe middle name), than i have & if there is another person, and aftert that First Name second person and Middle name last person. I need a way to extract those inside my query so i have something like this
select (conditions to get this) as Seller1First, (conditions to get this) as Seller1Middle, (conditions to get this) as Seller1Last, (conditions to get this) as Seller2First, Seller2Last from .......
This is MYSQL, but I added the sql topics too since is related.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER