select field0001 as '属具编号', field0002 as '锤型号',field0003 as '属具状态',field0004 as '所属设备',field0005 as '保修期止',field0006 as '保修期起',field0007 as '当前位置',field0012 as '夹板宽度',field0020 as '中缸体编号',field0021 as '属具状态汉字',field0043 as '新增方式',field0045 as '上次上机设备',field0046 as '最后一次上机表时',field0055 as '处理金额',field0057 as '审批流程',field0069 as '上一次保养后工作时间',field0070 as '累计工作时间',field0071 as '采购金额',field0072 as '租赁单价',field0074 as '最后一次上机日期',field0076 as '最近一次上机表时',field0077 as '动态工作表时',field0078 as '动态剩余小时',field0079 as '保养剩余小时',field0080 as '最近更新表时'from`formmain_6003`WHEREfield0001 LIKE '%${属具编号}%' and field0002 LIKE '%${锤型号}%' and field0021 LIKE '%${属具状态}%' and field0007 like '%${属具位置}%'order by if(field0021="已注销",0,1) desc,field0021条件如上因为field0007里有NULL，结果原来总数有122，设置上条件 field0007 like '%${属具位置}%' 后，就变成了110.目的想要显示所有含有NULL的特此求助！！！
