uot;Alex Behrens" <[EMAIL PROTECTED]>; "MYSQL" <[EMAIL PROTECTED]>
Sent: Monday, November 25, 2002 8:25 AM
Subject: Re: displaying a letter based on a query value
> Greetings...
>
> I thin you need to look into the enum datatype. It stores data as integer
> but wh
Greetings...
I thin you need to look into the enum datatype. It stores data as integer
but when queried it will return data in text.
Rgds
Insane
SQLyog - The Definitive GUI for MySQL
http://www.webyog.com/sqlyog/download.html
- Original Message -
From: "Alex Behrens" <[EMAIL PROTECTED]>
> Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)
> Phone: 651-482-8779
> Cell: 651-329-4187
> Fax: 651-482-1391
> ICQ: 3969599
> Owner of the 3D-Unlimited Network:
> http://www.3d-unlimited.com
> Send News:
> [EMAIL PROTECTED]
> - Original Message -
> F
ride" <[EMAIL PROTECTED]>
To: "Alex Behrens" <[EMAIL PROTECTED]>; "MYSQL" <[EMAIL PROTECTED]>
Sent: Sunday, November 24, 2002 5:08 PM
Subject: Re: displaying a letter based on a query value
> select if(captain = 1, 'C', ''
; <[EMAIL PROTECTED]>
To: "DL Neil" <[EMAIL PROTECTED]>; "MYSQL"
<[EMAIL PROTECTED]>
Sent: Sunday, November 24, 2002 3:53 PM
Subject: Re: displaying a letter based on a query value
> Hey,
>
> I'm not sure how to implement this into my query, i looke
t; <[EMAIL PROTECTED]>
Sent: Sunday, November 24, 2002 4:38 PM
Subject: Re: displaying a letter based on a query value
> Hey Alex
>
> > select captain from stats where captain > 0 and number = '23' group by
> > number;
> >
> > this returns a 1 for any
Hey Alex
> select captain from stats where captain > 0 and number = '23' group by
> number;
>
> this returns a 1 for any player with the number that matches being a
> captain, however it display a 1 is it possible to make that 1 displayed as
a
> C on my page?
MySQL allows an IF() within the SELE
