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