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


