In MySQL 8, the in condition is used for multiple fields

1. There is no primary key ID of the A table in the B table, but there are 2 other fields of the A table. Now plan to query the records in the A table based on the other 2 fields of the A table. Plan to use in conditions. The general standard usage is shown below

select * from `shops` where `id` in (14, 1, 21, 54, 55, 23, 49, 56)

2. Try using the in condition for multiple fields. The query was successful, in line with expectations. as shown in Figure 1

Figure 1

SELECT * FROM `customers` WHERE ( name, email ) IN (( '123', '123@outlook.com' ),
( '我是客户姓名33', '1303842899@qq.com' ))