MYSQL IF value = null OR value = ""

Question

I have this part of query:

IF(orders = NULL OR orders = '', "value1', 'value2')

which works with empty cells but not with null ones, any help? When it's NULL it doesn't make anything but when it's '' it runs the query

possible duplicate of [MySQL: selecting rows where a column is null](http://stackoverflow.com/questions/3536670/mysql-selecting-rows-where-a-column-is-null) — GSerg, Oct 13 '13 at 10:12

score 6 · Accepted Answer · answered Oct 13 '13 at 10:13

6

It's spelled orders is NULL (not orders = NULL).

answered Oct 13 '13 at 10:13

thebjorn

score 0 · Answer 2 · answered Oct 13 '13 at 10:57

0

You have to use

IF(orders IS NULL OR orders = '', 'value1', 'value2')

instead

answered Oct 13 '13 at 10:57

VahiD

2 Answers2