adress stored as an array

Hi, I have an address stored as a serialized array address[0] = my street; address[1] = Edinburgh; address[2] = Scotland; This is what I have. I want if it is possible to extract all the UNIQUE towns from my database. This is what the on of the entires looks like in my database.

Re: adress stored as an array

Ross Hulford wrote: Hi, I have an address stored as a serialized array address[0] = my street; address[1] = Edinburgh; address[2] = Scotland; This is what I have. I want if it is possible to extract all the UNIQUE towns from my database. This is what the on of the entires looks like in my