这是sql
SELECT sp.productType, LENGTH(sp.productType) as len, SUBSTR(sp.productType FROM 1 FOR (LENGTH(sp.productType) - 1)) as sub,
LENGTH(SUBSTR(sp.productType FROM 1 FOR (LENGTH(sp.productType)-11))) as sublen FROM DigiOneProductCenter.sale_product sp WHERE sp.productType LIKE '%(预付版)' LIMIT 50;
这是sql执行的结果
[img]http://dl.iteye.com/upload/attachment/0077/9272/1e636fd7-eba6-3bf3-9e92-fc58376cf99d.png[/img]
为什么没有改变字符的长度。