关于MySQL的迷糊匹配

直接上代码

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”)