Keoma Borges
Reputation: 694
Select a field. If it's null, select another
In my user table, there's email and number fields. I have to select the email. But if it is null, select the number. Can I do this in one query?
Thanks.
Upvotes: 2
Views: 121
Answers (1)
John Woo
Reputation: 263703
you can use COALESCE
SELECT COALESCE(email, number)
FROM tableName
From Docs,
Returns the first non-NULL value in the list, or NULL if there are no non-NULL values.
Upvotes: 4
Related Questions
- SELECT row if certain field is NOT null. Else, select row with null field instead
- MySQL - Select row if field has value, otherwise select with null value
- select a column if the other column already selected is null
- SELECT one column if the other is null
- SQL IF SELECT query is null then do another query
- SQL query, only select if column is not null else don't select
- Another select statement if the value is NULL
- MySQL SELECT with conditionally NULL column
- MySQL : Selecting alternative field if given field is empty
- Select different field in mysql if a field is set to null?