Laravel
초성검색 (ㄱ,ㄴ,ㄷ,ㅁ,ㅂ...)
짱구를왜말려?
2023. 4. 4. 15:13
반응형
SMALL
# What?
컬럼에 ㄱ, ㄴ같은 초성 포함여부 검색하기
# How?
if($char == "ㄱ")
$items = Community::whereBetween("title", ["가", "깋"]);
if($char == "ㄴ")
$items = Community::whereBetween("title", ["나", "닣"]);
if($char == "ㄷ")
$items = Community::whereBetween("title", ["다", "딯"]);
if($char == "ㄹ")
$items = Community::whereBetween("title", ["라", "맇"]);
if($char == "ㅁ")
$items = Community::whereBetween("title", ["마", "밓"]);
if($char == "ㅂ")
$items = Community::whereBetween("title", ["바", "빟"]);
if($char == "ㅅ")
$items = Community::whereBetween("title", ["사", "싷"]);
if($char == "ㅇ")
$items = Community::whereBetween("title", ["아", "잏"]);
if($char == "ㅈ")
$items = Community::whereBetween("title", ["자", "짛"]);
if($char == "ㅊ")
$items = Community::whereBetween("title", ["차", "칳"]);
if($char == "ㅋ")
$items = Community::whereBetween("title", ["카", "킿"]);
if($char == "ㅌ")
$items = Community::whereBetween("title", ["타", "팋"]);
if($char == "ㅍ")
$items = Community::whereBetween("title", ["파", "핗"]);
if($char == "ㅎ")
$items = Community::whereBetween("title", ["하", "힣"]);
LIST