Re: SELECT help

[Peter Brawley]

drop table if exists emails;
create table emails(ou char(8),email_address char(128));
insert into emails values('-','ou default addr'),('home','1st_addr'),('home','2nd_addr'),('home','');

SELECT 
  IF( LENGTH(email_address)>0,
      email_address,
      (SELECT email_address FROM emails WHERE ou = '-')
    ) as addr 
FROM emails 
WHERE ou LIKE 'HOME%' ; 
+-----------------+
| addr            |
+-----------------+
| 1st_addr        |
| 2nd_addr        |
| ou default addr |
+-----------------+

What's the issue?