[UPHPU] discovered ISNULL() for default join values in MySQL

[Sean Thayne]

You can also use a slick function called coalesce which most db  
engines support.


- Sean Thayne

On Feb 22, 2010, at 4:57 PM, Wade Preston Shearer <wadeshearer.lists at me.com 
 > wrote:

> I just discovered MySQL's ISNULL() and am using it to produce a  
> default value in a left join. I thought that I would share in case  
> it helps anyone else.
>
> _______________________________________________
>
> UPHPU mailing list
> UPHPU at uphpu.org
> http://uphpu.org/mailman/listinfo/uphpu
> IRC: #uphpu on irc.freenode.net