Link to home
Start Free TrialLog in
Avatar of rafaelrgl
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.
ASKER CERTIFIED SOLUTION
Avatar of chaau
chaau
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rafaelrgl
rafaelrgl

ASKER

Thanks for your help. I have award the points because this is first part of that question. I have created another question with more 2 3 rules. I also update the sample, because is last, first second name format, and on the first question i put first, last sec. here is the link for second question: https://www.experts-exchange.com/questions/29011241/Formating-field-in-mysql-Advance-formatting.html