Select by priority again
| From: | Bernie Huang | Date: | Mon, 24 Jul 2000 18:20:33 +0000 |
| Subject: | Select by priority again | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-1437@lists.php.net to get a copy of this message | ||
Sorry about this, but I don't quite get previous postings regarding
select by prioriry.
I have the same question with my sql. I want to be able to select
cell_phone if there is one in the table; otherwise, I will select
work_phone.
table
------
id, name, address, cell_phone, work_phone,...
and I tried using "case when...end" but nope, it's not gonna work. Help
is needed. Thanks.
- Bernie