How to organize MySQL table and retrieve specific records
I have some questions about how to design my table. My website will be a directory of top restaurants in the world. I'm going to have city-specific pages that will list the restaurants in that city. So, I could have a page with 10 restaurants in Paris. Each listing includes a link to that restaurant's own page which provides more information about that restaurant.
Should I have one huge table with all of the restaurants, with for example, 5000 rows or have city-specific tables. If I use the former, how would I code my select queries to extract the city-specific rows? The latter would probably be pushing it, but from an organizational standpoint it would be nice to have a table with just the info for that city.
Could someone please give me some pointers?
Thank you in advance!