既然不包含特殊字符,下面语句可以把中文选出来,怎么选英数再想想
SELECT
TRANSLATE(pp,'#0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz', '#') p1 FROM table_a
SELECT
TRANSLATE(pp,'#0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz', '#') p1 FROM table_a
select TRANSLATE(pp,'#'||TRANSLATE(pp,'#0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz', '#'),'#') from table_a
循环字段pp2
循环字段中的每个字母3
转换成ASCII,可以判断出来是英文还是中文
不知道可以吗