MySQL Query : SELECT COUNT(*) AS num FROM `w_wlyu_cn`.`cms_haoma` WHERE `status` = '99' AND `yunyingshang` = 2 AND `buhan` = '9' AND ( floor(mid(right(haoma,4),1,1))=floor(mid(right(haoma,1),1,1)) and floor(mid(right(haoma,5),1,1))= floor(mid(right(haoma,2),1,1)) and floor(mid(right(haoma,3),1,1))<> floor(mid(right(haoma,2),1,1)) ) LIMIT 1
    MySQL Error : Unknown column 'buhan' in 'where clause'
    MySQL Errno : 1054
    Message : Unknown column 'buhan' in 'where clause'