MySQL and ENUM fields

[silent]

It's kind of complicated to explain, but I need to retrieve the numeric index value of ENUM'd fields.

I need the numeric index value so that I can pass it in a URL string. (passing the stored string value of that ENUM is NOT an option, otherwise I would just do that)

Thanks in advance

[glenser]

Found this on page 458 of "MySQL Reference Manual":

If you retrieve an ENUM in a numeric context, you get the index value. Example:

mysql> SELECT enum_col+0 FROM tbl_name WHERE...

If you store a number into an ENUM, the number is treated as an index (Not in LOAD DATA, then treats all as strings). Example:

mysql> UPDATE tbl_name SET enum_col=1 WHERE...

Note: Empty enum_col returns 0, and index of null returns NULL.

Good luck!