mysql 大于小于不可在一个不等式中同时写

# 同时写大于小于，等于没写这个不等式条件
SELECT * FROM `my_table` WHERE c like '20%' and 8<=CHAR_LENGTH(c)<=10;
等价于
SELECT * FROM `my_table` WHERE c like '20%';


# 正确写法是分开写
SELECT * FROM `my_table` WHERE c like '20%' and 8<=CHAR_LENGTH(c) and CHAR_LENGTH(c)<=10;