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