MySQL选择列不为空

比较

phone2

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

请注意，

NULL

false