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

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

posted @ 2014-04-22 17:06  红鲤鱼与驴与绿鲤鱼  阅读(594)  评论(0编辑  收藏  举报