I have a table within a MySQL database with various data in it (for the sake of example, let's give it the following:
ID | Place | Phone | Email | Category )
Now, I want to redesign the "Category" section to be able to include any given row in multiple (searchable) categories.
For example, let's say that there is a place called 'Lakeside Picnic Area.' Currently it is classified as 'Nature Reserve'. So, when people are searching for a nature reserve, it shows in their search results. However, I also want it to show up in "Food Area", "Wildlife", and "Viewing Point".
My question is this: How do I design my table/database structure to allow all of the data entries/rows to be searchable by multiple categories?