I have a mysql table with contacts.
In this table I have a field called id_city and city_name.
I have another table called states where I have id_state, state_name and, related to it, all the id_city that are in that state.
I would like to prepare a query that shows me all the contacts living in all the city in a state using simply the state name...
How can I achieve this?