mysql 查询结果对字段某个值进行内容替换 将国家为0的值替换为随即国家 其他值原样显示

SELECT id, case proxy_sub_account.country when '0' then '随机国家' else country END as country from proxy_sub_account WHERE account_id = '1'

男女约束

select t....,t...., case t.gender when '1' then '男' else '女' end as gender from xxx t