MySQL | data validation

Question

How can i make it so that with a MySQL column you can only input certain options i.e. 'YES', 'NO'

I know this is possible but i can't find how to do this and searching online hasn't helped!

Thank you,

Mureinik · Accepted Answer · 2014-11-05 18:06:31Z

3

The cleanest way of doing this is probably to define an enum type:

CREATE TABLE my_table (
    my_column ENUM('YES', 'NO')
);

answered Nov 5, 2014 at 18:06

Mureinik

316k54 gold badges400 silver badges405 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

A tinyint(1) with a value of 1 or 0 will also work, but which is more optimized?

you need to use set sql_mode='STRICT_ALL_TABLES'; then otherwise no error will be raised in case of wrong value