为懒人提供无限可能,生命不息,code不止
作者: whooyun发表于: 2023-03-02 14:26
for 循环or
SQL
SELECT
*
FROM
acv_gds_category
WHERE
corp_id = ?
AND
is_deleted = ?
(
cat_no
LIKE
CONCAT(
''
,?,
'%'
)
OR
<
select
id
=
"selectLikeCatNos"
resultType
"com.zbw.saas.data.archives.goods.entity.AcvGoodsCategory"
>
select * from acv_gds_category where corp_id = #{corpId} and is_deleted = #{isDeleted}
foreach
collection
"list"
item
"item"
open
"AND ("
close
")"
separator
"or"
cat_no like CONCAT('',#{item},'%')
</