SELECT
a
FROM
b
WHERE
'xxxxx' LIKE concat('%', b.DESCRIPTION, '%')
GROUP BY length(REPLACE('xxxxx',b.DESCRIPTION,''))
LIMIT 1
获取匹配度高的数据结果
最新推荐文章于 2023-03-20 16:47:10 发布
SELECT
a
FROM
b
WHERE
'xxxxx' LIKE concat('%', b.DESCRIPTION, '%')
GROUP BY length(REPLACE('xxxxx',b.DESCRIPTION,''))
LIMIT 1