SELECT
id,
CASE name
WHEN'Test1' THEN 1 #判断name的值是否等于Test1,等于则改变查询出来的值为1
ELSE 0
END AS isexist, #字段重命名
qty,createdate,createby
FROM
stu
SELECT
id,
CASE name
WHEN'Test1' THEN 1 #判断name的值是否等于Test1,等于则改变查询出来的值为1
ELSE 0
END AS isexist, #字段重命名
qty,createdate,createby
FROM
stu