Is there a way to force SOME value to be returned from a SELECT query when
the result is empty set?  For instance:

SELECT nameColumn from theDatabase WHERE rowID = 5;

(when no row has ID "5")

result --> empty set

I would like for it to return some value, such as '' or 0 . . .

Thanks,

John


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to