mysql concat two field with null

https://dba.stackexchange.com/questions/110949/how-to-exclude-null-values-inside-concat-mysql


MySQL concat  return null if one of the concated fields is null .
to avoid this issue use

CONCAT_WS(" ","field_one","field_two","and so on")