修改sql,某个字段是否为空
SELECT
id,
CASE
name
WHEN '' THEN
NULL ELSE name
END AS name
FROM
users
WHERE
is_valid = 1
修改sql,某个字段是否为空
SELECT
id,
CASE
name
WHEN '' THEN
NULL ELSE name
END AS name
FROM
users
WHERE
is_valid = 1