mysql 字段 count 问题

luxury515 发布于 2017/02/16 10:21
阅读 121
收藏 0

SELECT wr_subject,
count(CASE WHEN city like '%서울%' THEN 1 END) as seoul,
count(CASE WHEN city like '%인천%' THEN 1 END) as incheon,
count(CASE WHEN city like '%부산%' THEN 1 END) as busan,
count(CASE WHEN city like '%제주%' THEN 1 END) as jeju,
count(CASE WHEN city like '%서귀포%' THEN 1 END) as seogwipo

count (些什么呢????) as 其他?????
from sq_write_ICBXML

自己写了一段, 但不知道怎么写“其他” 。。。

帮一下忙~~~

加载中
返回顶部
顶部