Junios World

초성으로 검색 ㄱ,ㄴ,ㄷ,ㄹ,으로 가,나,다 검색

하려고 할때  아래와 같이 하면 된다. 그러나 검색 정렬까정 느린긴 하다

switch ( $szFind )
{
 case "ㄱ":
  $szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^(ㄱ|ㄲ)' OR ( file_name >= '가' AND file_name < '나' ) order by file_name";
  break;

 case "ㄴ":
  $szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^ㄴ' OR ( file_name >= '나' AND file_name < '다' ) order by file_name";
  break;

 case "ㄷ":
  $szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^(ㄷ|ㄸ)' OR ( file_name >= '다' AND file_name < '라' ) order by file_name";
  break;

 case "ㄹ":
  $szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^ㄹ' OR ( file_name >= '라' AND file_name < '마' ) order by file_name";
  break;

 case "ㅁ":
  $szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^ㅁ' OR ( file_name >= '마' AND file_name < '바' ) order by file_name";
  break;

 case "ㅂ":
  $szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^ㅂ' OR ( file_name >= '바' AND file_name < '사' ) order by file_name";
  break;

 case "ㅅ":
  $szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^(ㅅ|ㅆ)' OR ( file_name >= '사' AND file_name < '아' ) order by file_name";
  break;

 case "ㅇ":
  $szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^ㅇ' OR ( file_name >= '아' AND file_name < '자' ) order by file_name";
  break;

 case "ㅈ":
  $szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^(ㅈ|ㅉ)' OR ( file_name >= '자' AND file_name < '차' ) order by file_name";
  break;

 case "ㅊ":
  $szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^ㅊ' OR ( file_name >= '차' AND file_name < '카' ) order by file_name";
  break;

 case "ㅋ":
  $szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^ㅋ' OR ( file_name >= '카' AND file_name < '타' ) order by file_name";
  break;

 case "ㅌ":
  $szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^ㅌ' OR ( file_name >= '타' AND file_name < '파' ) order by file_name";
  break;

 case "ㅍ":
  $szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^ㅍ' OR ( file_name >= '파' AND file_name < '하' ) order by file_name";
  break;

 case "ㅎ":
  $szQuery = "SELECT file_name FROM title_tbl where file_name RLIKE '^ㅎ' OR ( file_name >= '하') order by file_name";
  break;
}

//ㄱ만 ㅎㅎ
//SELECT file_name FROM title_tbl where file_name RLIKE '^(ㄱ|ㄲ)' OR ( file_name >= '가' AND file_name < '나' ) order by file_name

움.