이 같은 것?, 테스트되지 않았습니다.
$select = $sql->select ('user');
$select->columns(array(
'user_dob',
'currbirthday' => new Expression('user_dob + INTERVAL(YEAR(CURRENT_TIMESTAMP) - YEAR(user_dob)) + 0 YEAR')))
->order (
new Expression('
CASE WHEN currbirthday < CURRENT_TIMESTAMP
THEN currbirthday + INTERVAL 1 YEAR
ELSE currbirthday
END'
)
);
출처
https://stackoverflow.com/questions/22089824