[thelist] MySQL multiple counts problem

Cristian Rosescu crosescu at gmail.com
Fri Feb 13 00:14:21 CST 2009


I have a MySql database that contains a 'motels' table. One of the fields in
the table is 'breakfast_available' and this contains an integer (1 for yes,
0 for no). The other field in this table is 'conference_facilities' which
also stores an integer value 1 or 0

I would like to setup one MySql query that will display this number of
motels have breakfast available (breakfast_available = 1) and this number of
motels provide conference facilities (conference_facilities = 1)

Thank you for your help in advance

More information about the thelist mailing list