Ok,
im looking for this function in mysql..
in oracle its
select NVL(column1, column2) from dual;
if column1 is NULL then set the value to column2
whats the command for this in mysql??
i tried IFNULL but doesnt seem to work.
😕
Im not a MySQL expert, but I have read the MySQL manual Funciton section, and I do not remember ever reading about a function like that. I can see how this would be handy, let me know what you come up with.
Sorry
PHPdev
SUX!
I like how mysql says they "compare" to oracle in performance...LOL, but they dont deliver basics functions like NVL.
BAH!!
ANYBODY else?
NVL is a Oracle specific function. Use coalesce instead.