Preventing duplicates on non-key fields

[y2k1981]

is there a way that you can put an index on a field (like in access) so that duplicates aren't allowed? in access, you can put an index on a field and say duplicates OK or no duplicates allowed. can you do the same in MySQL?

 

[ingresman]

create unique index <name> on table(columns)
should do it

 

[y2k1981]

cool, i'll give that a go