I'm using a junction table which holds the columns hotel_ids and features_ids.
In order to filter the hotels according to the chosen features, I'm using a WHERE clause such as WHERE f.features_name='room service'. But what must I do if there are multiple features? Must I use AND or OR, such as WHERE f.features_name='room service' OR f.features_name='internet access'? The main thing is that only those hotels that have all of the chosen features are returned.
I am stumped. Thank you in advance.