checkBox 여러 컬럼 저장하고 수정하기

<th scope="row">a컬럼</th>
<td>
<input type="checkbox" name="abc1" value="${data.abc1}" title="망고" id="checkYn_abc1" > 망고
<input type="checkbox" name="abc2" value="${data.abc2}" title="수박" id="checkYn_abc2" > 수박
<input type="checkbox" name="abc3" value="${data.abc3}" title="딸기" id="checkYn_abc3" > 딸기
<input type="checkbox" name="abc4" value="${data.abc4}" title="멜론" id="checkYn_abc4" > 멜론
</td>

<script type="text/javascript">
$(function() {
 	 $("input:checkbox").change(function(){
	      if(this.checked){
	        $(this).attr('value', 'O');
	      }else{
	        $(this).attr('value', 'X');
	      }
	    });
	 
   $("input:checkbox").each(function() {
        if ($(this).val() === 'O') {
          $(this).prop("checked", true);
        } else {
          $(this).prop("checked", false);
        }
      }); 
      
 }

</script>

SELECT
IFNULL(SUBSTRING(A.abc, 1, 1), 'X') AS abc1
, IFNULL(SUBSTRING(A.abc, 2, 1), 'X') AS abc2
, IFNULL(SUBSTRING(A.abc, 3, 1), 'X') AS abc3
, IFNULL(SUBSTRING(A.abc, 4, 1), 'X') AS abc4
FROM table명

DB에 저장할땐 OOXX 이런식으로 저장을 하게 된다