字符串常用: https://www.cnblogs.com/xixuyan/p/8074290.html
instr详解 https://www.cnblogs.com/dshore123/p/7813230.html
使用字符串查找和取子串
SUBSTR(hb.remark,INSTR(hb.remark,‘retMsg’),(INSTR(hb.remark,‘transactionID’)-INSTR(hb.remark,‘retMsg’)-2)) as subs
length(string); //取字符长度
lengthb(string); //取字节长度