<div>
SELECT first_name,email1<br />
UNION ALL<br />
SELECT first_name,email2<br />
UNION ALL<br />
SELECT first_name,email3<br />
FROM family<br />
<br />
Error Code: 1054. Unknown column 'first_name' in 'field list'
</div>


<div>
this answer is close to the question<br />
because I think a union would work<br />
<br />
<br />
thank you
</div>


<div>
<div class="content wysiwyg-content">
table has email1 email2 email3<br />
varchar<br />
<br />
I want to select the row (name,phoneNumber) for each email
</div>
</div>


table has email1 email2 email3
varchar

I want to select the row (name,phoneNumber) for each email

numerous varchar columns in one row

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.