Code: Select all
SELECT surname,addressname,children, add1,add2,town,county,postcode,phone,mobile,email,email2 FROM address ORDER BY surnameHow do I do that?
Moderator: General Moderators
Code: Select all
SELECT surname,addressname,children, add1,add2,town,county,postcode,phone,mobile,email,email2 FROM address ORDER BY surnameCode: Select all
SELECT CONCAT(add1,', ',add2,', ',postcode) AS address.....
Code: Select all
select CONCAT_WS(", ", add1, add2, town, county, postcode) AS address FROM table