提取字段的某一部分值

 select  NO_FILTRATE.userId,NO_FILTRATE.depName,NO_FILTRATE.empName,NO_FILTRATE.iState, ComputerName ,NO_FILTRATE.IP ,LEFT(A.clientInfo, INSTR(A.clientInfo, ';') - 1),NO_FILTRATE.loginUserName,NO_FILTRATE.OS,NO_FILTRATE.SetUpTime,NO_FILTRATE.BackMess,NO_FILTRATE.clientState  from  T_SC_UserManager AS NO_FILTRATE, T_SC_ClientIdentifier AS A   where  userId > 0 and NO_FILTRATE.pcName = A.clientID  order by NO_FILTRATE.pcName desc  limit 0, 100