mysql - 如何选择满足条件的行(如果存在)，否则选择所有行？

Question

我想仅选择 name='David' 存在的行，如果没有这样的行

我想选择*行。以下是我的声明，但不起作用:

SELECT * FROM table A
Where name='David'
else
SELECT * from table A

Answer 1

使用下面的查询就可以了

  select m1.name from
   (
    select m1.*, case when m1.name ='David' then 1  else 0  end  as cnt from tableA m1 ) m1
     inner join 
    (
    select max(Cnt) as Cnt from
    (
     select t1.*, case when name ='David' then 1  else 0  end  as Cnt 
      from tableA t1
     ) as t2

     )as n 
     on m1.cnt=n.Cnt

http://sqlfiddle.com/#!9/88ed0c/2