mysql 拼接字段

select spot_position,req_line,CONCAT(spot_position,'-',req_line) 
  from pdm_qc_apply 
where req_qctype != '2';

结果展示：