SELECT
a
FROM
b
WHERE
'xxxxx' LIKE concat('%', b.DESCRIPTION, '%')
GROUP BY length(REPLACE('xxxxx',b.DESCRIPTION,''))
LIMIT 1
获取匹配度高的数据结果
最新推荐文章于 2022-06-14 14:19:00 发布
SELECT
a
FROM
b
WHERE
'xxxxx' LIKE concat('%', b.DESCRIPTION, '%')
GROUP BY length(REPLACE('xxxxx',b.DESCRIPTION,''))
LIMIT 1