MYSQL: Multiple values in column
My database and columns:
province (province_id, ..)
city (city_id, province_id, ..)
model (model_id, age, height_in_cm, hair_color, measurements, eye_color, description, ..)
model_in_city (model_id, city_id)
Now I want to display all models in the chosen city by the user but each model can chose up to 4 city placements. How can this be done?
|