SELECT
if(LOCATE( ‘1’, t.id )=0,999,LOCATE( ‘1’, t.id ) ) ,t.*
FROM
admin_shop t
ORDER BY
if(LOCATE( ‘1’, t.id )=0,999,LOCATE( ‘1’, t.id ) )
mysql根据匹配度排序
最新推荐文章于 2024-06-28 10:39:34 发布
SELECT
if(LOCATE( ‘1’, t.id )=0,999,LOCATE( ‘1’, t.id ) ) ,t.*
FROM
admin_shop t
ORDER BY
if(LOCATE( ‘1’, t.id )=0,999,LOCATE( ‘1’, t.id ) )