//一个列匹配多个关键词,并按倒序排列
SELECT
GOODS_NM,
GOODS_TYPE
FROM
PI_STOCK_GOODS
ORDER BY
(CASE WHEN charindex('三星', GOODS_NM) > 0 THEN 1 ELSE 0 END ) +
(CASE WHEN charindex( 'galaxy', GOODS_NM ) > 0 THEN 1 ELSE 0 END) +
(CASE WHEN charindex( 'note10', GOODS_NM ) > 0 THEN 1 ELSE 0 END) DESC
//多个列匹配一个内容
select * from PI_STOCK_GOODS where charindex('galaxy' ,GOODS_NM+GOODS_CD)>0