$query.="ORDER BY ";
$query.="( ";
$query.="CASE ";
$query.="WHEN cd_kyganjee LIKE %자 THEN 1 ";
$query.="WHEN cd_kyganjee LIKE %축 THEN 2 ";
$query.="WHEN cd_kyganjee LIKE %인 THEN 3 ";
$query.="WHEN cd_kyganjee LIKE %묘 THEN 4 ";
$query.="WHEN cd_kyganjee LIKE %진 THEN 5 ";
$query.="WHEN cd_kyganjee LIKE %사 THEN 6 ";
$query.="WHEN cd_kyganjee LIKE %오 THEN 7 ";
$query.="WHEN cd_kyganjee LIKE %미 THEN 8 ";
$query.="WHEN cd_kyganjee LIKE %신 THEN 9 ";
$query.="WHEN cd_kyganjee LIKE %유 THEN 10 ";
$query.="WHEN cd_kyganjee LIKE %술 THEN 11 ";
$query.="WHEN cd_kyganjee LIKE %해 THEN 12 ";
$query.="ELSE 13 ";
$query.="END ";
$query.="), ";
$query.="cd_no DESC ";
$query.="LIMIT 0 , 110";
△
△[홈마스타]