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.
MySQL ServerSQL

Avatar of undefined
Last Comment
rafaelrgl

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
chaau

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
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
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23