1.应用场景
查询name时,若alias有值,则使用alias的值,如果为空,则还用name.
2.实现
SELECT
CASE
WHEN alias = '' THEN
name ELSE alias
END AS name,
FROM
mapconfig
WHERE
1.应用场景
查询name时,若alias有值,则使用alias的值,如果为空,则还用name.
2.实现
SELECT
CASE
WHEN alias = '' THEN
name ELSE alias
END AS name,
FROM
mapconfig
WHERE