2021-09-30

sql筛选 没有后缀名的图片

 
     select
      item_id as itemId,
	  title,
	  img_url as imgUrl
     from
	  ghq_item
     where
	  title like  concat ("%",#{title},"%")
	 and img_url like concat("%","pj") or img_url like concat("%","pg") or img_url like concat ("%","NG" )or  img_url like concat("%", "PG")
	 and is_del = 0
	 and status =1