MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  gender TEXT NOT NULL,
  xYear INTEGER,
  xMonth INTEGER,
  xDay INTEGER 
);
insert into students values (1,'A','A',2023,1,12);
insert into students values (2,'B','B',2023,1,12);
insert into students values (3,'C','C',2023,1,11);
insert into students values (4,'D','D',2023,1,12);
insert into students values (5,'E','E',2023,1,11);
insert into students values (6,'F','F',2023,1,11);
insert into students values (7,'G','G',2023,1,12);
insert into students values (8,'H','H',2023,1,12);
SELECT 
id, name, gender,  
xYear, xMonth, xDay
FROM students
WHERE 
  CAST(CONCAT(xYear,'-',xMonth,'-',xDay) AS DATE) 
    = CURDATE() - INTERVAL 1 DAY;


id
name
gender
xYear
xMonth
xDay


1
A
A
2023
1
12

2
B
B
2023
1
12

4
D
D
2023
1
12

7
G
G
2023
1
12

8
H
H
2023
1
12


SELECT 
id, name, gender,  
xYear, xMonth, xDay
FROM students
WHERE 
  CONCAT(xYear,'-',xMonth,'-',xDay) = CURDATE() - INTERVAL 1 DAY


id
name
gender
xYear
xMonth
xDay


1
A
A
2023
1
12

2
B
B
2023
1
12

4
D
D
2023
1
12

7
G
G
2023
1
12

8
H
H
2023
1
12