LMSouq
database Open

MySQL select where column is not empty

MI
mike
1 month ago
3 views
Problem Description
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.

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base