记录一下 case when吧（用在where后筛选条件）

SELECT
	PrUser.*
FROM
	PrUser
WHERE
	(PrUser. STATUS != '4')
AND (
	PrUser. STATUS = '1'
	OR PrUser. STATUS = '2'
)
AND PrUser.uid NOT LIKE '%admin%'
AND CASE
WHEN (
	PrUser.jlunit IS NOT NULL
	AND PrUser.jlunit <> ''
) THEN
	(PrUser.jlunit = ?)
WHEN (
	PrUser.partUnitId IS NOT NULL
	AND PrUser.partUnitId <> ''
) THEN
	(PrUser.partUnitId = ?)
WHEN (
	PrUser.orgId IS NOT NULL
	AND PrUser.orgId <> ''
) THEN
	(PrUser.orgId = ?)
END
AND PrUser.eid = 'esc'
ORDER BY
	PrUser.wechat ASC 

主要是case when then  第一次用这玩意，然后同时判断不为空和不为null