How to check for NULL or empty String?

[vsr1]

CREATE INDEX ix1 ON default(IFNULL(parent_id,""));
SELECT ...  
FROM default
WHERE  IFNULL(parent_id,"") = "";

If you want missing also use IFMISSINGORNULL()