记录sql/hql [SQL中的LEFT/RIGHT/SUBSTRING函数] LEFT(field,length) RIGHT(field,length) SUBSTRING(field,start,length) LEFT/RIGHT函数返回field最左边/最右边的length个长度的字符串 SUBSTRING函数返回field从start开始共length个长度的字符串 hql中substr(substring)函数截取字符串匹配 substr(string A, int start, int len) substring(string A, int start, int len)