Can I search my cusomers by location?

[nonfinite]

I need to compile a list of customers in California. Is this possible? If so, how do I do it?

Title typo, sorry about that.

[nonfinite]

Help, I need to do this pretty soon! I have about 4 days to get word out to my customers I'll be in CA.

[Ajeh]

You have the tables:
customers
address_book

that contain this information ...

The default address in the customers table is referenced in the field:
customers_default_address_id

this will match up with the address_book field:
address_book_id

and the customers table field:
customers_id

will match up with the address_table field:
customers_id

You need to decide if you want all addresses in the address_book or just when they are the default address ...