SELECT
displayed_dtc,
dtc_code,
name_cn
FROM
diagnostic_data_dtc
WHERE
diagnostic_info_id = 2061
and INSTR(CONCAT(displayed_dtc, dtc_code),"A2")
-- and CONCAT(displayed_dtc, dtc_code) LIKE "%B22A054%"
-- AND ( displayed_dtc LIKE "%A2A054%" OR dtc_code LIKE "%A2A054%" )
ORDER BY
create_time DESC
INSTR(CONCAT(displayed_dtc, dtc_code),“A2”) 类似 like %A2%,
CCONCAT(displayed_dtc, dtc_code),“A2”)等同于
CONCAT_WS(“”, displayed_dtc, dtc_code),“A2”)