Looking for a sample sql statement to query a db table that boolean data.
Here is the scenario...
Records are lodging businesses with fields for each of the amenities. Example of fields below.
After db is complete users will need to be able to query the db by checking checkboxes of the amenities they desire, click search, and have only those businesess appear with relavent amenities.
What might the a sameple sql statement look like for this? FYI... at this time unknown how many amenities fields there might be and may need to add new amenities at any time.
Select * From TableName Where.....
View Complete Post