Re: IF Statement in Select : MySQL 5.1 v. 5.5
> in 5.1 it sets PRRef as Blob.
It does this in the mysql client, or in phpMyAdmin, or in some other client, in which case which?
Is processID a char column by any chance?
> What I'm trying to do is show a null value as spaces rather than 0
?! It tests for 0, not null. To show null values of processID as spaces, write ifnull(processID,'').
Subject
Written By
Posted
Re: IF Statement in Select : MySQL 5.1 v. 5.5
August 16, 2014 11:55AM
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.