drop table temp_20221221;

create table temp_20221221

 (char1 varchar(500));

insert into temp_20221221

(char1) values ("2022年催化剂第8批网上竞价TJ20221221");

insert into temp_20221221

(char1) values ("2022年催化剂第9批网上竞价TJ20221221");

insert into temp_20221221

(char1) values ("2022年催化剂第10批网上竞价TJ20221221");

select char1,substr(char1,INSTR(char1,'第')+1,INSTR(char1,'批')-INSTR(char1,'第')) FROM temp_20221221