[thelist] MySQL multiple counts problem
Cristian Rosescu
crosescu at gmail.com
Fri Feb 13 00:14:21 CST 2009
Hi,
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