Hi,
I have first_name, middle_name and last_name in my customers table.
I want to do
SELECT CONCAT(first_name, ' ', middle_name, ' ', last_name)
The middle name is optional
so I want to ignore it if it's blank to be:
SELECT CONCAT(first_name, ' ', last_name)
because if I do it the normal way I'll have extra space between the first_name and last_name
