Combine Into One Query ????

[m i l e s]

Hi,

Im wondering if there is a way to combine the following queries into  
ONE query, or at the very least fewer queries...????  (DATE) is  
today's date.

        SELECT DISTINCT ip_address
        FROM logfile
        WHERE site_id = xxxxx
        AND date_time LIKE (DATE)
        GROUP BY ip_address     
                                                                                
                        
        SELECT a_browser
        FROM logfile
        WHERE site_id = xxxxx
        AND date_time LIKE (DATE)
                                                                                
                                
        SELECT a_browser
        FROM logfile
        WHERE site_id = xxxxx
        AND date_time LIKE (DATE)
        AND a_browser LIKE "%MAC%"                                              
                                                                                      
        SELECT a_browser
        FROM logfile
        WHERE site_id = xxxxx
        AND date_time LIKE (DATE)
        AND a_browser LIKE "%WIN%"

        SELECT a_browser
        FROM logfile
        WHERE site_id = xxxxx
        AND date_time LIKE (DATE)
        AND a_browser NOT LIKE "%WIN%"
        AND a_browser NOT LIKE "%MAC%"

        SELECT a_browser
        FROM logfile
        WHERE site_id = xxxxx
        AND date_time LIKE (DATE)
        AND a_browser LIKE "%NETSCAPE%"
        AND a_browser LIKE "%WIN%"
        AND a_browser LIKE "%WINDOWS%"
        
        SELECT a_browser
        FROM logfile
        WHERE site_id = xxxxx
        AND date_time LIKE (DATE)
        AND a_browser LIKE "%NETSCAPE%"
        AND a_browser LIKE "%MAC%"
                
        SELECT a_browser
        FROM logfile
        WHERE site_id = xxxxx
        AND date_time LIKE (DATE)
        AND a_browser LIKE "%FIREFOX%"
        AND a_browser LIKE "%WIN%"
        AND a_browser LIKE "%WINDOWS%"
        
        SELECT a_browser
        FROM logfile
        WHERE site_id = xxxxx
        AND date_time LIKE (DATE)
        AND a_browser LIKE "%FIREFOX%"
        AND a_browser LIKE "%MAC%"
                                                
        SELECT a_browser
        FROM logfile
        WHERE site_id = xxxxx
        AND date_time LIKE (DATE)
        AND a_browser LIKE "%MSIE%"
        AND a_browser LIKE "%WIN%"
        AND a_browser LIKE "%WINDOWS%"
                
        SELECT a_browser
        FROM logfile
        WHERE site_id = xxxxx
        AND date_time LIKE (DATE)
        AND a_browser LIKE "%MSIE%"
        AND a_browser LIKE "%MAC%"
                
        SELECT a_browser
        FROM logfile
        WHERE site_id = xxxxx
        AND date_time LIKE (DATE)
        AND a_browser LIKE "%SAFARI%"
                
        SELECT a_browser
        FROM logfile
        WHERE site_id = xxxxx
        AND date_time LIKE (DATE)
        AND a_browser NOT LIKE "%SAFARI%"
        AND a_browser NOT LIKE "%FIREFOX%"
        AND a_browser NOT LIKE "%NETSCAPE%"
        AND a_browser NOT LIKE "%MSIE%"
        AND a_browser NOT LIKE "%MAC%"
        AND a_browser NOT LIKE "%WIN%"
                
        SELECT a_browser
        FROM logfile
        WHERE site_id = xxxxx
        AND date_time LIKE (DATE)
        AND a_browser NOT LIKE "%SAFARI%"
        AND a_browser NOT LIKE "%FIREFOX%"
        AND a_browser NOT LIKE "%NETSCAPE%"
        AND a_browser NOT LIKE "%MSIE%"
        AND a_browser LIKE "%MAC%"
        AND a_browser LIKE "%MOZ%"
                
        SELECT a_browser
        FROM logfile
        WHERE site_id = xxxxx
        AND date_time LIKE (DATE)
        AND a_browser NOT LIKE "%SAFARI%"
        AND a_browser NOT LIKE "%FIREFOX%"
        AND a_browser NOT LIKE "%NETSCAPE%"
        AND a_browser NOT LIKE "%MSIE%"
        AND a_browser LIKE "%WIN%"
        AND a_browser LIKE "%MOZ%"

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]