I'm not sure I understand the question.
first off, yes is a string, so the query should be:
SELECT * FROM artist WHERE id=1 AND makeup = 'yes'
using makeup = 'yes' in the where clause will exclude records where NULL is used since NUll is not equal to yes
are you trying to return records where the makeup column contains either NULL or yes?
in that case:
SELECT * FROM artist WHERE id=1 AND (makeup = 'yes' OR makeup = NULL)