平成30/ 2018-10-22 00:46
MYSQL, Case, When, 2018.08.13

CASE
    WHEN gender = '男' THEN 1
    WHEN gender = '女' THEN 2
    ELSE 99
END