About
Pricing
Community
Teams
Start Free Trial
Log in
rgb192
asked on
12/27/2012
numerous varchar columns in one row
table has email1 email2 email3
varchar
I want to select the row (name,phoneNumber) for each email
MySQL Server
3
1
Last Comment
rgb192
8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Bradley Fox
12/27/2012
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
rgb192
12/29/2012
ASKER
SELECT first_name,email1
UNION ALL
SELECT first_name,email2
UNION ALL
SELECT first_name,email3
FROM family
Error Code: 1054. Unknown column 'first_name' in 'field list'
rgb192
1/12/2013
ASKER
this answer is close to the question
because I think a union would work
thank you
Your help has saved me hundreds of hours of internet surfing.
fblack61
UNION ALL
SELECT first_name,email2
UNION ALL
SELECT first_name,email3
FROM family
Error Code: 1054. Unknown column 'first_name' in 'field list'