MySQL select where column is not empty

Question

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 the phone starts with 813 and phone2 has something in it.

Answer 1

You can compare the value of phone2 with an empty string like this:

select phone, phone2 

from jewishyellow.users 

where phone like '813%' and phone2<>''

Note: Here, the NULL value is interpreted as false.