[SOLVED] joining columns from one table
Posted: Thu Nov 23, 2006 10:02 am
I have a MYSQL database table called address with columns surname, addressname,add1,add2,town,county,postcode...
Is it possible to query it so that add1,add2,town,county,postcode could be returned as 'address' formatted "add1, add2, town, county, postcode"? Further can it ignore an empty add2 field?
Code: Select all
SELECT surname,addressname,add1,add2,town,county,postcode FROM address