How to show a column, but if it has null show another sql such as a table named Task.
| id | nome | nome resumido | +-----+----------+----------------+ | 1 | nome 1 | 1 | | 2 | nome 2 | 2 | | 3 | nome 3 | null |
sql will get the short name, where it is null it takes the name for example:
| id | as nome | +-----+----------+ | 1 | 1 | | 2 | 2 | | 3 | nome 3 |
If you can not get into sql I'm using the language in php
As commented on in the question itself, it can be done using the COALESCE :
SELECT id, COALESCE(nome_resumido, nome) as nome
FROM nome_tabela
You can also use the IFNULL :
SELECT id, IFNULL(nome_resumido, nome) as nome
FROM nome_tabela
In addition to these, as suggested in another answer, it can be done using CASE :
SELECT id,
CASE nome_resumido is null THEN nome
ELSE nome_resumido END as nome
FROM nome_tabela
Friend you can use mysql CASE:
SELECT nome, nome_resumido,
CASE
WHEN nome_resumido IS NULL OR nome_resumido = '' THEN nome
ELSE nome_resumido
END AS Nome
FROM Users;
I hope to have helped my friend.
I do not know if I understood better.
Using ISNULL / function operator.
Select ISNULL(a, b)
b is selected if a for Null.
You can even use WHEN / THEN a Select option, look for the "BOL" better.
Essentially: It's the c switch / case block in SQL.