SELECT *
FROM garbage
WHERE name LIKE CONCAT('%', #{keyword}, '%')
ORDER BY LENGTH(name), CASE WHEN name LIKE CONCAT(#{keyword}, '%') THEN 1
WHEN name LIKE CONCAT('%', #{keyword}) THEN 2
ELSE 3
END;
mysql模糊查询时按关键字位置从前往后排序,字数从少到多
于 2024-04-14 15:00:58 首次发布