Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.


Member since Dec 11, 2008

Recent Blog Comments By mike

  • MySQL Does Not Support IF / ELSE Statements In General SQL Work Flow

    Posted on Nov 2, 2008 at 2:09 PM

    I would like to include if logic into my stored proc as follows: CREATE PROCEDURE `ABCD`( IN A VARCHAR (25), IN B VARCHAR (25), IN C VARCHAR (75), IN D VARCHAR (25) ) BEGIN SELECT X FROM Y WHERE Z = A IF X isDefined then return X ELSE SELECT M FROM N WHERE P = B IF Y isDefined then return Y ELS... read more »