List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 24 2003 1:00am
Subject:Re: ENUM
View as plain text  
At 19:34 -0400 5/23/03, Urb LeJeune wrote:
>	I'm trying to extract the enumeration from a field defined as
>Action enum('M', 'S', 'H', 'D' ) in a table named FieldInfo.
>	As I interpret the manual the command
>SELECT * FROM FieldInfo WHERE Action=0
>	I'm getting an empty set. Can anyone point me in the
>right direction?

Sequential enumeration values are assigned values beginning with 1.
0 represents '', which is used for illegal values.  If all
values in the column are one of the four values you show, an
empty set would be the expected result.

What are you trying to accomplish?


Paul DuBois
sql, query
ENUMUrb LeJeune24 May
  • Re: ENUMMartin Gainty24 May
  • Re: ENUMPaul DuBois24 May
    • Re: ENUMUrb LeJeune24 May
      • Re: ENUMPaul DuBois24 May
        • Re: ENUMUrb LeJeune24 May
          • Re: ENUMYerra Venkata Srinivasa Rao24 May
          • Re: ENUMPaul DuBois24 May