INSERT into SELECT from

insert into TABLE1
(field1, field2, field3, field4)
select 'value1', 'value2', field3, field4
from TABLE1 where field5 = 'value5' limit 1;