Hi everyone. I am fairly new to mysql and have found a data type that may my life easier but am not sure I am taking a shortcut.

I use lookup tables quite often in my models and have found that "enum" will give me the same functionality without having all of those other lookup tables around.

What would be the "correct" or the best option. Should I just use enum and forego the other tables?

Thanks! Frank

Hey guys, was my question that far out in left field?

stay far away from the dreaded, evil ENUM

the horror! the horror!

do a search on "dreaded evil enum" for more info...

Thanks for the reply r937. I will do a search on that now.