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