MySQL PHP wildcard? fetching column from tables
I have a html form what lets the user's choose from a list certain people's email. One the user chooses those emails and hits submit, in a MySQL table "UserChosenEmails" column "email" those emails get added. This table only has emails column. Now I have another table named "UserInfo" with 2 columns, email and number. UserInfo table has emails and numbers of ALL emails not just the ones the user choose. What I am trying to do here is fetch the numbers of the emails in "UserChosenEmails" but this column only has specific emails but no phone numbers so how can I take all the emails in "UserChosenEmails" and fetch their numbers from "UserInfo"'s number column?
MySQL PHP wildcard? fetching column from tables
===

I have a html form what lets the user's choose from a list certain people's email. One the user chooses those emails and hits submit, in a MySQL table "UserChosenEmails" column "email" those emails get added. This table only has emails column. Now I have another table named "UserInfo" with 2 columns, email and number. UserInfo table has emails and numbers of ALL emails not just the ones the user choose. What I am trying to do here is fetch the numbers of the emails in "UserChosenEmails" but this column only has specific emails but no phone numbers so how can I take all the emails in "UserChosenEmails" and fetch their numbers from "UserInfo"'s number column?