how to validate date null in mysql?

Question

I'm working with MariaDB. when I try to show some result don't show me nothing.

select 
    if(fecha is null,'hello','bye') dat
from 
    table

I'm trying to show me some result, but I don't know how?

your query checks if the column has a `NUL`, as you have no rows it will not check anything — nbk, Dec 02 '20 at 21:19
Well no rows = no result. Non-existing rows are not considered to be NULL entities. — Alex K., Dec 02 '20 at 21:20
do you just want a result that tells you if there are any rows? or do you want a result for each row, or 1 result if there are no rows? — ysth, Dec 02 '20 at 22:14

nbk · Accepted Answer · 2022-05-11T07:32:50.353

0

You can use something like this

CREATE TABLE t1 (fecha  VARCHAR(2))

SELECT IF( COUNT(*) = 0 , 'Empty',`fecha`) FROM t1

| IF( COUNT(*) = 0 , 'EMpty',`fecha`) |
| :---------------------------------- |
| EMpty                               |

db<>fiddle here

edited May 11 '22 at 07:32

answered Dec 02 '20 at 21:22

nbk

1 Answers1