﻿select * from bible
where btext like '%침례%';
update bible
set btext = replace(btext, '침례', '세례')
where btext like '%침례%';
commit;

-- 한자 성경
select * from bible
where btext like '%浸禮%';
update bible
set btext = replace(btext, '浸禮', '洗禮')
where btext like '%浸禮%';
commit;

-- 만나주석
-- 1번
select * from bible
where btext like '%침례%';
update bible
set btext = replace(btext, '침례', '세례')
where btext like '%침례%';
commit;
-- 2번
select * from bible
where btext like '%浸禮%';
update bible
set btext = replace(btext, '浸禮', '洗禮')
where btext like '%浸禮%';
commit;
-- 3번 세례(洗禮) --> 세례(洗禮, 침례(浸禮))
update bible
set btext = replace(btext, '세례(洗禮, 침례(浸禮))', '세례(洗禮)')
where btext like '%세례(洗禮)%';
commit;


-- HebGrkKo.dct 수정할 때 사용
select * from lexicon
where dtext like '%침례%';

update lexicon
set dtext = replace(dtext, '침례', '세례')
where dtext like '%침례%';
commit;

-- 한번 더 해줘야 함(괄호부분의 순서를 바꿔줌)
update lexicon
set dtext = replace(dtext, '세례(세례)', '세례(침례)')
where dtext like '%세례(세례)%';
commit;