mysql - select true when count is greater than zero

Viewed 27026

I have the following query.

SELECT COUNT( * ) AS offer_count
  FROM restaurants_offers
WHERE DATE( NOW( ) ) 
   BETWEEN date_start
   AND date_end
AND restaurant_id =1

Now, when count is greater than zero I want to select true else false, instead of count as the query result. How to do that?

3 Answers
Related