mysql - 查询为空时如何显示内容？

Question

如果查询完成，我有这段代码显示“1”，当查询为空时如何显示“0”。

SELECT  1 as 'access' 
FROM  `mytable` 
WHERE  `name` = 'Prophet Muhammad' and id = 1;

Answer 1

使用 COUNT

SELECT  (COUNT(*) >= 1) as 'access' 
FROM    mytable
WHERE   name = 'Prophet Muhammad' and 
        id = 1;

• SQLFiddle Demo