Loop in MySQL - how to make a copy with a change of one cell for each selected row?

Question

MySQL

Good afternoon!
Tell me how to make it so that by selecting rows, then copying them, replacing each of them with a certain value?
and then I got tired of unloading and replacing in a notepad :)

Answer 1

insert into table (select id,p1,p2,p3,35,p5 from table where ...)
well, very rude, but something like this - 35 will be written instead of p4