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