thinkphp 合并两个字段组合成一个临时字段concat函数
$this->whereLike('job_no|user_name', '%' . $user . '%')->field('id as value,concat(user_name," - ",job_no) as title')->select(); $this->whereLike('job_no|user_name', '%' . $user . '%')->field('id as value,concat(user_name," - ",job_no) as title')->select(); SELECT t.TABLE_SCHEMA AS '库名称', t.TABLE_NAME AS '表名', t.COLUMN_NAME AS '字段名', t.COLUMN_TYPE AS '字段类型...