select sysagentofficelabelphone from tcc_c_agent tca 如果office为QWE123 只截取前三位显示
SELECT sys, agent, SUBSTRING(office, 1, 3) AS office, label, phone FROM tcc_c_agent tca WHERE office = 'QWE123'
原文地址: https://www.cveoy.top/t/topic/ixFA 著作权归作者所有。请勿转载和采集!