Re: Handle return of empty set from select

[Peter Brawley]

BBCode tag delimiters are square brackets [] not angle brackets <>.

Is this what you mean?

create procedure best( IN in_state VARCHAR(255) ) 
  begin    
    set @result='';
    select Hospital_Name into @result
    from hospital_outcomes 
    where Death_Rates_Heart_Attack > 0 and State = in_state
    order by Death_Rates_Heart_Attack, Hospital_Name    
    Limit 1;
    select ifnull(@result,'Empty');
  end;