If I have this - tadd is the
CONCAT(tadd.street_number, ' ', tadd.street_name,', ', tadd.apt_number,', ', tadd.city,', ', tadd.postal_code,', ', tadd.country) AS 'Address'
Is there a way to exclude the apt_number if it doesn't exist?
I was thinking of:
WHERE tadd.apt_number IS NOT NULL
But it will return only those rows with
apt_number, and even if something works how do I then deal with that extra comma.
If it's a duplicate please post a link in comments.