我有这段mysql代码:
SELECT firstname, lastname, age, gender from persons WHERE id = 1;
显示:
> firstname: Marlon
>
> lastname: Null
>
> age: 26
>
> gender: male
What I want to do is:
SELECT IF NULL DONT SELECT(firstname), IF NULL DONT SELECT(lastname), IF NULL DONT SELECT(age), IF NULL DONT SELECT(gender) from persons WHERE id = 1;
显示:
> firstname: Marlon
>
> age: 26
>
> gender: male
因为它是空的,所以未显示lastname。