进行子查询：
SELECt [some fields]FROM SELECt firstname, lastname, CONCAt(firstname, ' ', lastname) as fullname FROM people) AS tmpWHERe firstname LIKE '%user_submitted_data%'OR lastname LIKE '%user_submitted_data%'OR fullname LIKE '%user_submitted_data%'
进行子查询：
SELECt [some fields]FROM SELECt firstname, lastname, CONCAt(firstname, ' ', lastname) as fullname FROM people) AS tmpWHERe firstname LIKE '%user_submitted_data%'OR lastname LIKE '%user_submitted_data%'OR fullname LIKE '%user_submitted_data%'
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
