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
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 field
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 I Put a 'Literal' Value in a Report Column?