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 (meaning yes, this animal was adopted) or 0 (no, this animal has > not been adopted). > > So far I: > "SELECT Name, Adopted FROM animal". This prints a column of animal names > and a column labeled "Adopted" with row after row of 0's and 1's. I want > my output report to say 'Y' if 'adopted' = 1 or 'N' if adopted = 0.
Two options: 1) Do it in the program that actually makes the query. 2) Use MySQL's CASE statement to convert values on the fly to Y and N. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
