mysql 查询某值是否存在于某结果集或表中

author Owner  •  Filed under templates, internet

(CASE
    WHEN colomnName IN (
        select xxx from table
    ) THEN
        'Y'
    ELSE
        'N'
    END
) AS aliasName

Tagged: orci, lectus, varius, turpis

Comments (0)  • 2020-04-26 10:09:14 •  Edit

0 Responses

最新文章