在MySQL用函数concat拼接字符串问题

Question

SELECT
    telephone,
    SUBSTR(telephone FROM 7 FOR 5) AS '新尾号规则',
    custom_pro_tel 'B1'
FROM
    protel
WHERE
    telephone NOT IN (
        SELECT
            telephone
        FROM
            protel
        WHERE
             SUBSTR(telephone FROM 6 FOR 6) = CONCAT('0', '1', '2', '3', '4', '5')
         or SUBSTR(telephone FROM 6 FOR 6) = CONCAT('1', '2', '3', '4', '5', '6')
    )
AND SUBSTR(telephone FROM 7 FOR 5) = CONCAT('0','1', '2', '3', '4')
or SUBSTR(telephone FROM 7 FOR 5) = CONCAT('1', '2', '3', '4', '5')
OR SUBSTR(telephone FROM 7 FOR 5) = CONCAT('2', '3', '4', '5', '6')

为什么我查询后5位的，排除后6位的，排除不了？有人知道么？

Answer 1

为什么用Concat不直接用字符串？你的tel from 6 to 6是个什么结果？我用Sqlite很容易就排除了

sqlite> select tel,SUBSTR(tel,6,8) as x from test ;
111100000|0000
111200000|0000
111300000|0000
111310000|0000
sqlite> select tel,SUBSTR(tel,6,8) as x from test where SUBSTR(tel,5,8) != '10000';
111100000|0000
111200000|0000
111300000|0000