How to use like query with count value in mysql -


i wish use count value of table in search. how can do? query shows #1111 - invalid use of group function

  select driver_details.driverid,             count(taxi_trip.autoid) totaltrip,             sum(taxi_trip.tripdistance) totaltripdistance,             sum(taxi_trip.totalfare)  totaltripfare     driver_details           left join taxi_trip            on taxi_trip.driverid = driver_details.driverid             , taxi_trip.pickuplat != 0             , taxi_trip.droplat != 0             , taxi_trip.totalfare != 0     (date_format(taxi_trip.requestdate,'%y-%m-%d') >= 2015-07-17)       , (date_format(taxi_trip.requestdate,'%y-%m-%d') <= 2015-07-17)       , (driver_details.driverid '%sa%'       or driver_details.firstname '%sa%'       or driver_details.lastname '%sa%'       or driver_details.taxiplateno '%sa'       or count(taxi_trip.autoid) '%sa%'       or sum(taxi_trip.tripdistance) '%sa%'       or sum(taxi_trip.totalfare) '%sa%')     group taxi_trip.autoid 

try rewriting using having

select driver_details.driverid,        count(taxi_trip.autoid) totaltrip,        sum(taxi_trip.tripdistance) totaltripdistance,        sum(taxi_trip.totalfare)  totaltripfare  driver_details      left join taxi_trip       on taxi_trip.driverid = driver_details.driverid        , taxi_trip.pickuplat != 0        , taxi_trip.droplat != 0        , taxi_trip.totalfare != 0  group taxi_trip.autoid  having (date_format(taxi_trip.requestdate,'%y-%m-%d') >= 2015-07-17)    , (date_format(taxi_trip.requestdate,'%y-%m-%d') <= 2015-07-17)    , (driver_details.driverid '%sa%'    or driver_details.firstname '%sa%'    or driver_details.lastname '%sa%'    or driver_details.taxiplateno '%sa'    or count(taxi_trip.autoid) '%sa%'    or sum(taxi_trip.tripdistance) '%sa%'    or sum(taxi_trip.totalfare) '%sa%')  

Comments