ABOUT ME

-

Today
-
Yesterday
-
Total
-
  • 한글자음 검색
    MYSQL 2020. 5. 28. 09:49
    if($find == 'ㄱ'){ 
     $where = "and (field_name RLIKE '^(ㄱ|ㄲ)' OR ( field_name >= '가' AND field_name < '나' )) order by field_name"; 
    }else if($find == 'ㄴ'){ 
     $where = "and (field_name RLIKE '^ㄴ' OR ( field_name >= '나' AND field_name < '다' )) order by field_name"; 
    }else if($find == 'ㄷ'){ 
     $where = "and (field_name RLIKE '^(ㄷ|ㄸ)' OR ( field_name >= '다' AND field_name < '라' )) order by field_name"; 
    }else if($find == 'ㄹ'){ 
     $where = "and (field_name RLIKE '^ㄹ' OR ( field_name >= '라' AND field_name < '마' )) order by field_name"; 
    }else if($find == 'ㅁ'){ 
     $where = "and (field_name RLIKE '^ㅁ' OR ( field_name >= '마' AND field_name < '바' )) order by field_name"; 
    }else if($find == 'ㅂ'){ 
     $where = "and (field_name RLIKE '^ㅂ' OR ( field_name >= '바' AND field_name < '사' )) order by field_name"; 
    }else if($find == 'ㅅ'){ 
     $where = "and (field_name RLIKE '^(ㅅ|ㅆ)' OR ( field_name >= '사' AND field_name < '아' )) order by field_name"; 
    }else if($find == 'ㅇ'){ 
     $where = "and (field_name RLIKE '^ㅇ' OR ( field_name >= '아' AND field_name < '자' )) order by field_name"; 
    }else if($find == 'ㅈ'){ 
     $where = "and (field_name RLIKE '^(ㅈ|ㅉ)' OR ( field_name >= '자' AND field_name < '차' )) order by field_name"; 
    }else if($find == 'ㅊ'){ 
     $where = "and (field_name RLIKE '^ㅊ' OR ( field_name >= '차' AND field_name < '카' )) order by field_name"; 
    }else if($find == 'ㅋ'){ 
     $where = "and (field_name RLIKE '^ㅋ' OR ( field_name >= '카' AND field_name < '타' )) order by field_name"; 
    }else if($find == 'ㅌ'){ 
     $where = "and (field_name RLIKE '^ㅌ' OR ( field_name >= '타' AND field_name < '파' )) order by field_name"; 
    }else if($find == 'ㅍ'){ 
     $where = "and (field_name RLIKE '^ㅍ' OR ( field_name >= '파' AND field_name < '하' )) order by field_name"; 
    }else if($find == 'ㅎ'){ 
     $where = "and (field_name RLIKE '^ㅎ' OR ( field_name >= '하')) order by field_name"; 
    }else{
     $where = "order by field_name";
    }
    
    $qry     = "select * from table_name where $where";
    $result  = mysql_query($qry);

    'MYSQL' 카테고리의 다른 글

    mysql 삭제시 용량 안줄어 들었을경우  (0) 2020.06.01
    mysql varchars date order by sort  (0) 2020.06.01
    mysql order by 특수문자 를 뒤로  (0) 2020.06.01
    sqlyog 인코딩 변경하기  (0) 2020.05.28
    날짜 중복 체크 쿼리  (0) 2020.05.15

    댓글

Designed by Tistory.