regular = indexes the value, which makes queries faster, but its not unique
unique = you cas only have one instance of that value in the field. So if you had two records with "test" as the value, it would reject the 2nd one as there was already one in the DB. Normally this is reserved for ID's where you don't want duplication
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
unique = you cas only have one instance of that value in the field. So if you had two records with "test" as the value, it would reject the 2nd one as there was already one in the DB. Normally this is reserved for ID's where you don't want duplication
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!