Problem with mysql query, filter where

0

Will it be mysql error?

mysql > select user_ad, name, assignment from users where assignment = 'NULL';

Does anyone know why the last query MysQL does not show the NULL record of danielad ?, it is assumed that doing the NULL filter on the assignment field should show me all that agree, but in this case not

    
asked by zereft 10.11.2018 в 22:43
source

1 answer

0

I think you should try the following:

select usuario_ad, nombre, asignacion from usuarios where asignacion is null;
    
answered by 10.11.2018 в 22:55