SELECT concat(
IFNULL(t.source,''),
IFNULL(t.gender,''),
IFNULL(t.`name`,''),
IFNULL(t.email,''),
IFNULL(t.house_holder,''),
IFNULL(t.work_years,''),
IFNULL(t.expected_salary,''),
IFNULL(t.expected_position,''),
IFNULL(t.work_status,''),
IFNULL(t.work_address_province,''),
IFNULL(t.work_address_city,''),
IFNULL(t.work_address_district,''),
IFNULL(t.address_province,''),
IFNULL(t.address_city,''),
IFNULL(t.address_district,'')
) as expectJobArr from
t_talent as t
where expectJobArr LIKE '%%'
Mysql的concat合并多列实现like关键词查询
于 2022-05-12 11:16:38 首次发布