would this be the answer?

Code:
SELECT case when (MONTH(date) >=1 AND MONTH(date) <=3) then "1st Quarter"
                     when (MONTH(date) >=4 AND MONTH(date) <=6) then "2nd Quarter"
                     when (MONTH(date) >=7 AND MONTH(date) <=9) then "3rd Quarter"
                     when (MONTH(date) >=10 AND MONTH(date) <=12) then "4th Quarter"
             end as quarter
FROM table