Do you want to use CONCAT with NULL fields in MySQL? If you just use CONCAT with some null field, you’ll get a null concatenated field.

Just use IFNULL() in MySQL.

CONCAT(IFNULL(NAME_A,”), IFNULL(NAME_B,”)) as NEW_NAME

Rodolfo