select substr(column,posstr(column,'cc'),10) from table posstr(column,'cc'):相当于java indexOf substr:截取函数