empty set

[Rocio Gomez Escribano]

Hi!  I'm not sure it would be possible what I want to.

 

I have a huge query, most of them are independent, and they could have not
answer. What I want is when this happen, I want to change the "empty set" by
"void" or "0" or something like that, here it is an example:

 

mysql> select * from usuarios;
+-----------+--------+
| usuarioID | codigo |
+-----------+--------+
|         1 |    456 |
|         2 |    789 |
|         3 |    123 |
+-----------+--------+
3 rows in set (0.00 sec) 

 

mysql> SELECT usuarioID FROM usuarios WHERE codigo = 45;
Empty set (0.00 sec) 

 

 

+-----------+
| usuarioID |
+-----------+
|      Void |
+-----------+ 

 

Is it possible???

 

Thank you!!