|
select test, -- test 字段的所有内容
substr(test,-4) as test_str, -- test 字段的最后4个字符的内容
decode(substr(test,-4),'NANA',substr(test,1,length(test)-4),test) as test_str2 -- 如果test字段的最后4个字符是'NANA',则去掉最后4个字符;否则:原型显示test字段
from t;
TEST TEST_STR TEST_STR2
------------------------------ -------- ------------------------------------------------------------
aaaaa NANA NANA aaaaa
bbacd NANA NANA bbacd
dfweogjeoejhje.weog.seor NANA NANA dfweogjeoejhje.weog.seor
Luoyoumou Fuck you! you! Luoyoumou Fuck you! |
|