sql查找字符串是否包含字符

SELECT [Fgoodsid]
,[Fgoodsname]
,[Fcinema]
,[Fprice]
FROM [tenpaytest].[dbo].[goodsinfo]
where Fgoodsname like '%,2,%' or Fgoodsname like '2,%' or Fgoodsname like '%,2'

原文地址:https://www.cnblogs.com/yhdkzy/p/3680918.html