update 0p4_good_issue_note
set type="GIN";

update 0p4_good_issue_note
set type="GID"
where good_issue_note_no like "GID%";
