mysql中没有布尔类型值,MySQL中许多布尔值的替代方案？

let's say I have a checkbox search form like this:

Check all that interests you:

bowling

billiard

sweets

Can I request this data from a database instead of having to resort adding tons of booleans to a database such as this?

(VenueId, IfBowling, IfBilliard, IfSweets)

And maybe just have one column that would contain all of those options that the venue itself has?

解决方案

Alternative .. sure .. easy :

User table, Interests table, UserInterests table.

UserInterests is used to store many-to-many relation between Users and Interests, and contains values which are FOREGN KEYs from said tables.

P.S. You really should read SQL Antipatterns book. You would learn a lot from it.