行行比较,用于多字段多条件查询在此记录一下 select * from yoshop_goods where (goods_name, category_id) in (('柠檬茶', 1), ('维他奶', 2));