Where only in not NULL
I need some help with a SELECT
SELECT * FROM artist WHERE id=1 AND makeup = yes
The problem is makeup can be NULL and if its null the SELECT wont work.
I need to check IFNULL.
Like IF makeup NOTNULL then AND makup = yes
Can someone help me,