MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Using the compared value
Posted by: William Chiquito
Date: September 30, 2008 08:23AM

Hi Stephen,

Try: 
DECLARE result INT DEFAULT -1;
SET result = (SELECT...);
IF(result < 0, 'N/A',result);

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Using the compared value
2682
Stephen Barton
September 30, 2008 05:54AM
Re: Using the compared value
1935
William Chiquito
September 30, 2008 08:23AM
Re: Using the compared value
1888
Malcolm Cook
September 30, 2008 08:23AM
Re: Using the compared value
1876
Stephen Barton
October 01, 2008 12:35AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.