- 号码 套餐资费 卡费 话费 操作
- 号码 套餐资费 卡费 话费 操作
MySQL Query : SELECT COUNT(*) AS num FROM `www_haomahao_com`.`cms_haoma` WHERE `status` = '99' AND haoma not like '%3%' AND AND haoma like '%1%1%1%1%' AND kafei >= 200 and kafei <= 300 AND right(haoma,4) >= 1980 and right(haoma,4) < 1990 AND floor(mid(right(haoma,4),1,2)) = 02 and floor(mid(right(haoma,2),1,2)) <= 31 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 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND haoma like '%1%1%1%1%' AND kafei >= 200 and kafei <= 300 AND right(haoma,4) ' at line 1
MySQL Errno : 1064
Message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND haoma like '%1%1%1%1%' AND kafei >= 200 and kafei <= 300 AND right(haoma,4) ' at line 1
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND haoma like '%1%1%1%1%' AND kafei >= 200 and kafei <= 300 AND right(haoma,4) ' at line 1
MySQL Errno : 1064
Message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND haoma like '%1%1%1%1%' AND kafei >= 200 and kafei <= 300 AND right(haoma,4) ' at line 1