sql - PHP json_encode returns false -


i trying these data db , stuck @ case in query.

i trying so:

(case when e.email = null c.user  end) email 

basically want in case e.email turns null, want c.user e-mail. not working , new "advanced sql".

you want coalesce, return first non-null argument:

coalesce(e.email, c.user) email 

by way, in sql null = null returns null. have use is comparison operator when checking if value null i.e. e.email null opposed e.email = null


Comments

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

python Tkinter Capturing keyboard events save as one single string -

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -