Hi, I have one field called seller, and inside I have those kind of values
JAMROZ,STOMP F & MARIA N
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.