Group similar meta_key values and create result set with meta_value data

I have fields that look like this:

I want to select the data to meet the condition:

• meta_value of schedule_%_date is 2021/2/7 or 2021/2/8
• the number of '%' in schedule_%_lesson is equal to the number of '%' in the first condition

For example, with the condition above, I will get these data:

The code I've tried so far

SELECT * FROM 'table_name' WHERE (meta_key LIKE 'schedule_%_date' AND meta_value IN ('2021/02/07','2021/02/08')) OR (meta_key LIKE 'schedule_%_lesson')

Check this one out:

SELECT tt.meta_key AS lesson_key, tt.meta_value AS lesson_value,
  d.meta_key AS date_key, d.meta_value AS date_value
FROM `table_name` tt
JOIN
  (SELECT t.*, REPLACE(REPLACE(t.meta_key, 'schedule_', ''), '_date', '') AS key_num
  FROM `table_name` t
  WHERE t.meta_key LIKE '%schedule%date%'
    AND t.meta_value IN ('2021/2/7', '2021/2/8')) d
      ON d.key_num = REPLACE(REPLACE(tt.meta_key, 'schedule_', ''), '_lesson', '')
WHERE tt.meta_key LIKE '%schedule%lesson%'

It outputs data in a slightly different format, thought it might work for you as well:

This query though might not be optimal from indexes utilization perspective. Make sure to take this into consideration. Using % wildcard in the LIKE statements in the middle of search string reduces the performance of index.