How to handle NULL values in mysql/php?

Question

In MSSQL Server, we make queries for null values like below:

SELECT name, ISNULL(about, ''), contact FROM `user_profile` WHERE userid=1

But when I am trying to do the same with MYSQL then it gives error.

What is the logical and easy way to handle NULL values in php/mysql scenario.

Thanks

MatTheCat · Accepted Answer · 2010-10-07 08:40:49Z

8

It's IFNULL() for MySQL ^^ But in your case it seems you can return a NULL value, just use a condition to test it.

if(!$result['valuemaybenull']) -> true if 0, false or NULL

answered Oct 7, 2010 at 8:40

MatTheCat

18.8k6 gold badges59 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Yes, its resolved and I am trying to accept it as answer but don't know why SO keep saying "wait for 6 minutes".. will accept it after 6 minutes.. :)

^^ I don't know enough yet stackoverflow

Slavic · Accepted Answer · 2010-10-07 09:55:08Z

1

Be cautios about the following in MySQL:

SELECT 1=NULL returns NULL SELECT 1!=NULL return NULL (as well)

Whenever you want to check for null values use the IS NULL expression (or the above IFNULL)

answered Oct 7, 2010 at 9:55

Slavic

1,9822 gold badges17 silver badges31 bronze badges