CSV storage InnoDB?

Karl DeSaulniers <[email protected]>
Newsgroups gmane.comp.php.database
Message-ID <[email protected]>
Hello all,
Quick question.
What is the best way to store a comma separated list of discount codes  
in a InnoDB?
Text, varchar, blob, ? I want to be able to store discount codes  
offered to users in their profile, in their cart, etc.
So I am thinking of storing the codes as a comma separated list that I  
can then refer to, add to or remove codes from.
The codes will change every once and a while and they list of codes  
may be rather large after say a year,
so I am shying away from an enum() or anything like that.

Any help/pointers is greatly appreciated.

Best,
Karl


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.