So, I have a "filter results" section of my website. In my database, I have a table of video games with a column named gameConsole that stores the name of the console the game runs on. In my "filter results" section, there is a part where you can check some checkboxes to filter the results to specific consoles. Now, I have looked everywhere for a way to query same column for different items. For example, if somebody checked PS3 and PS4, the query should pull all PS3 and PS4 games. Other than having to run multiple queries, is there a way to query for both items in the table?
I hope this makes sense.