SQL에서 조건 검색문의 드립니다.
본문
테이블에 아래와 같이 필드가 있다고 하였을때에
테이블에서 "ㄱ"로 시작하는 문자열만 검색하고자 할경우 어떻게 해야 되나요?
wr_name
가나다
강남
강시
답변 2
$searchsql = "select * from tablename where ";
if($f_word == 'ㄱ')
$searchsql .= " substr(nick,1,1) between '가' and '낗'";
else if($f_word == 'ㄴ')
$searchsql .= " substr(nick,1,1) between '나' and '닣'";
else if($f_word == 'ㄷ')
$searchsql .= " substr(nick,1,1) between '다' and '띻'";
else if($f_word == 'ㄹ')
$searchsql .= " substr(nick,1,1) between '라' and '맇'";
else if($f_word == 'ㅁ')
$searchsql .= " substr(nick,1,1) between '마' and '밓'";
else if($f_word == 'ㅂ')
$searchsql .= " substr(nick,1,1) between '바' and '삫'";
else if($f_word == 'ㅅ')
$searchsql .= " substr(nick,1,1) between '사' and '앃'";
else if($f_word == 'ㅇ')
$searchsql .= " substr(nick,1,1) between '아' and '잏'";
else if($f_word == 'ㅈ')
$searchsql .= " substr(nick,1,1) between '자' and '찧'";
else if($f_word == 'ㅊ')
$searchsql .= " substr(nick,1,1) between '차' and '칳'";
else if($f_word == 'ㅋ')
$searchsql .= " substr(nick,1,1) between '카' and '킿'";
else if($f_word == 'ㅌ')
$searchsql .= " substr(nick,1,1) between '타' and '팋'";
else if($f_word == 'ㅍ')
$searchsql .= " substr(nick,1,1) between '파' and '핗'";
else if($f_word == 'ㅎ')
$searchsql .= " substr(nick,1,1) between '하' and '힣'";
else {}
출처: http://itrooms.tistory.com/180 [IT이야기 (영은파더)]
ㄱ 으로 검색하기 위해서는
$sql .= "select * from tablename where substr(column,1,1) between '가' and '낗'"
이런식으로 하죠.
다른방법이 있으려나요?
있으면 다른분께 패스~~