Closed
Description
GORM Playground Link
Description
调用方式:
req.Where("uuid1=? and uuid2=? and uuid3=? and biz_id in (?,'')", uuid1, uuid2, uuid3, bizId). Or("uuid1=? and uuid2=? and uuid3=? and biz_id=?", uuid1, uuid2, uuid3, bizId). First(&m1)
sql:
SELECT * FROM test_mysqlWHERE uuid1="TG2_DnnYM" and uuid2="HG2_YccDpp" and uuid3="HJlVYcnYpH" and biz_id in(9073505431267684724,'') OR uuid1="TG2_DnnYM" and uuid2="HG2_YccDpp" and uuid3="HJlVYcnYpH" and biz_id=9073505431267684724 AND user_id = '1010486059' AND tenant_id = "1053623233" ANDtest_mysql.deleted_atIS NULL ANDtest_mysql.id= 544 ORDER BYtest_mysql.id LIMIT 1