see 12.2 Control Flow functions of MySQL manual
select name, if(adopted=0,'N','Y') from animal;
> -Original Message-
> From: Sue Cram [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 07, 2005 2:58 AM
> To: mysql@lists.mysql.com
> Subject: How do
"Sue Cram" <[EMAIL PROTECTED]> wrote on 02/07/2005 02:57:59 AM:
> This is a pretty basic question, but I'm learning SQL from a book
> and it's very very frustrating!
>
> I'm writing a report listing animals from our shelter and whether
> they have been adopted. I am selecting the animal name
On Monday 07 February 2005 07:57, Sue Cram might have typed:
> I'm writing a report listing animals from our shelter and whether they have
> been adopted. I am selecting the animal name field and a field called
> 'adopted' from a table called 'animal'. The values in 'adopted' are
> either: 1 (m
This is a pretty basic question, but I'm learning SQL from a book and it's very
very frustrating!
I'm writing a report listing animals from our shelter and whether they have
been adopted. I am selecting the animal name field and a field called
'adopted' from a table called 'animal'. The va