2008-05-05 13:06:32
적용 예)
$sql .= " order by ";
$sql .= " if(b.bfno IS NULL or b.bfno='',2,1) asc, ";
$sql .= " b.berrcnt,";
$sql .= " if(b.bbunru='지상',1,2) asc, ";
$sql .= " if(b.bbunru='' or b.bbunru='웹' or b.bbunru IS NULL,'힣힣힣힣',b.bbunru) asc, ";

$sql .= " case when ASCII(SUBSTRING(b.bfcmt, 1)) >= 128 then '1' ";
$sql .= " when ASCII(SUBSTRING(b.bfcmt, 1)) >= 65 and ASCII(SUBSTRING(b.bfcmt, 1)) < 128 then '2' ";
$sql .= " else '3' ";
$sql .= " end ,";

$sql .= " b.bfcrday,b.bno,b.bsuns, b.bfno";   ▷