Is there any substitute for ifnull()

Question

I have a query for mysql where ifnull() is used.i want to convert it into ejb-ql. Problem here is that i dont find any substitute equivalent to ifnull() in ejb.

For eg:

ifnull(columnname,' ') as newcoulmn

May be `coalesce(columnname,' ') as newcoulmn` that's widely supported construction — Dmitry Bychenko, Jun 04 '14 at 12:11
Yes, this should be the soultion - `coalesce(columnname,' ')`. — prava, Jun 04 '14 at 13:06

Dmitry Bychenko · Accepted Answer · 2014-06-04T12:54:21.463

1

You may try

  coalesce(columnname, ' ') as newcolumn

since coalesce is widely supported function when ifnull is MySql specific one

edited Jun 04 '14 at 12:54

answered Jun 04 '14 at 12:13

Dmitry Bychenko

180,369
20
160
215

Thank you sir! I will try this and update u with the results asap. – Mufaddal Kagda Jun 04 '14 at 12:52

Is there any substitute for ifnull()

1 Answers1