this is a question about search() in pset8 Mashup.
How does one select rows given multiple characteristics(for example in pseudo code, SELECT * THAT CONTAIN KEYWORDS "New Haven" AND "Connecticut" AND "06404" AND "US" within ANY of the fields of PLACES database)
Right now, my code parses any search query (no matter how long) that sanitizes any non-alphabetic and non-number characters. I would have (in the case of my example) ["New Haven", "Connecticut", "06404", "US"].
How can I use my array (or any way) to select rows from my database that satisfy all the conditions above without knowing which characteristics goes with which keyword in the array?