In MySQL, can I select columns only where something exists?

For example, I have the following query:

select phone, phone2
from jewishyellow.users
where phone like '813%'
and phone2

I’m trying to select only the rows where phone starts with 813 and phone2 has something in it.

13 Answers
13

Tags:

Leave a Reply

Your email address will not be published. Required fields are marked *