SQL에서 조건 검색문의 드립니다. 채택완료

$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">http://itrooms.tistory.com/180 [IT이야기 (영은파더)]