no return value from empty table

[Thomas Svenson]

Hi list,

I'm new here so I don't know if this has been discussed earlier.

I have a problem with the following:
SELECT IF(column = 'string', 'a', 'b') AS test FROM table;

It works just fine if the table is populated. However, if the table is empty
(which this one very well can be from time to time) I get no return value at
all.

Is there any way I can get MySQL to return "test = b" if the table is empty?

/T
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw