【广告项目】mysql-select-if用法

来源:互联网 发布:淘宝商铺怎么开通花呗 编辑:程序博客网 时间:2024/03/29 20:12

mysql根据不同情况在一个字段显示不同值

SELECTa.*, d2. NAME AS typeName,IF (a.position = '列车媒体',d3.unit,d4.unit) AS suoshudanweiFROMta_advertisement aLEFT JOIN ta_dictionary_list d2 ON a.type = d2.idLEFT JOIN ta_trainmedia t1 ON a.position_id = t1.idLEFT JOIN ta_org_unit d3 ON t1.management_departmentId = d3.idLEFT JOIN ta_stationmedia s1 ON a.position_id = s1.idLEFT JOIN ta_org_unit d4 ON s1.companyId = d4.idWHEREa.delete1 = '1'

说明:若position为列车媒体,显示d3.unit的值赋给suoshudanwei,否则显示d4.unit的值赋给suoshudanwie


效果图:




原创粉丝点击